點樣用 excel plot calibration straight line??

you can not plot all point on the line becases they are no on the same line
you need trendline

Insert --> Chart
select XY (Scatter) chart type with points only, complete adding the chart
Clicking the series to select
right click and Add Trendline
The straight trendline and the point will be there. select the trendline to format or get the line equation

You need Linear Regression

Read here step by step
http://www.ncsu.edu/labwrite/res/gt/gt-reg-home.html

“串過”...
條線要串過既話,, 你個case講,, 只有2點..(事但2點..)
因為的點本來就唔係一條直線上面..

--00--