Geek Answers Handbook

Excel chart with custom standard deviation

I have 2 columns, one with my data points, the other with standard deviation for each data point. How to make a line graph on excel with errors equal to the standard deviations of each perspective point?

eg.

Col-1  Col-2
1      0.1
2      0.2
3      0.1
+5
source share
2 answers

Do the following (based on your example data above)

  • Create a line chart using your values ​​in Col-1 (i.e. 1,2,3)
  • In the diagram, place the cursor on the line and right-click and select "Data Series Format"
  • In the dialog box, select "Error Scales Y"
  • "" ""
  • "" " "
  • "+" "-" , Col-2 (0,1, 0,2, 0,1)
  • "Ok".

+3

Excel 2010, " " . :

  • , Col-1 (.. 1,2,3)
  • "" "" ""
  • " "...
  • "" " "
  • "" " " " "
  • "" "" , Col-2 (0,1, 0,2, 0,1)
  • "Ok"
+2

More articles:


All Articles