Wednesday, August 28, 2013

How to Make Standard Deviation Charts in Excel 2003


1. Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu and then click on the “Open” option.
2. Locate the Excel 2003 file that contains the chart you want to work with from your desktop or folder where you store your Excel files. Select the file so it’s highlighted, and click on the “Open” button.
3. Click on the line, bar or dots of your graph, which represent your data. Click on the “Format” option from the top toolbar menu and then click on the “Selected Data Series” option.
4. Select the shape or color of error bar you want from the “Display” list, including black dots and transparent squares. Select the 'Standard Deviation' option from the list below the “Error amount” field.
5. Click on the “Custom” option if you want to insert specific amounts for the standard deviation equation. Click on the “OK” button and the changes will be made to your chart.

Blogger news