MS-EXCEL: GOING FURTHER WITH GRAPHS I: ADDING ERROR BARS

Entering error bars on a scatter plot continued

Double click on the data point to open the dialogue box. Select the Y error bar menu.

Note this time for the scatter plot you will see an X error bar menu too. So you can put in horizontal error bars too.

Select error bars both above and below the data point and then select Custom (Fr: Personnalisée)

Select the data that is to be used for the upper error bar. Click left on the upper bar (+) the menu will disappear and you will be left with the box in which you have to select the cells containing the data for the error bars (in this case the standard deviation).

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 box.

Let go of the mouse button and the menu will reappear with the upper error bar box complete.

Repeat the procedure with the box for the lower error bar (-). Use the same cells for the standard deviations as before.

Finally click on OK or press Enter and the error bars will appear on the graph.

• Error Bars on a Scatter Plot - previous page
• Index Page
• Top of Page

© Paul Billiet 2010