How to Put Error Bars on Points in Excel

Office 2003
1. Right-click the data series (the points on the graph) and click 'Format Data Series.'
2. Click the tabs at the top of the window that read 'X Error Bars' or 'Y Error Bars' as necessary.
3. Select the error bar style under 'Display' and set the error amount as a fixed value, a percentage or a standard deviation.
4. Click 'OK' to apply the error bars.
Office 2007
5. Click on the graph and the 'Chart Tools' toolbar will appear at the top of the screen.
6. Select the 'Layout' tab and click the 'Error Bars' button found on the right side.
7. Click 'More Error Bars Options' and choose the style of error bar, and enter the error amount as a fixed value, percentage or standard deviation.
8. Click 'OK' to apply the error bars.