求救!! 幫我用excel 畫個graph!!

2006-12-09 9:16 pm

Length of the string (l) /m
0.80.750.70.650.60.550.50.45

T²/S²
3.2643463.0310812.8866012.6830442.5098482.2477512.0556391.852321

宜家我有呢d data.. 點樣用excel畫graph??
(x axis = Length of the string (l) /m, y axis = T²/S²)

唔想打個方法出黎可唔可畫左graph之後send俾我???
( [email protected])

更新1:

畫best-fit line得架啦

回答 (1)

用戶101377

2006-12-11 8:22 pm

✔ 最佳答案

1 Insert chart
2 select xy type
3 add a serise, select the x data using (l), select the y data using (T²/S²), Finish ploting
4 Add the trendline (linear best fit), select the series, right click, add trendline (linear), format the trendline add the equation

參考: myself

👍 0 👎 0

收錄日期: 2021-04-23 18:49:40
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061209000051KK02058

檢視 Wayback Machine 備份