The Open Door Web Site
Going Further with Graphs Index
ICT in Biology Index
ICT IN BIOLOGY
Using MS Excel 2013 : Going Further with Graphs
Error Bars Showing Standard Deviations
If you want to show standard deviations as error bars then you need to use a slightly different approach.
Data source shown in left column.
From the Chart Elements menu select Format Error Bars and Custom. Click on Specify Value.
Now the data that is to be used for the error bars has to be selected. You need to select the cells containing in the standard deviation (line 14) for both positive and negative error values.
Left click on the first cell and hold the button down whilst you run along the line for standard deviations. You will see the cell coordinates appear in the positive error values box. Repeat the same procedure for the negative error box.
Press Enter or click OK and the error bars will appear on the graph.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal