How to Create a Standard Deviation Graph in Excel

1. Open Excel. Open a data file or type the data into a series of columns with one value per column.
2. Click 'Insert' and select 'Scatter.'
3. Select the type of scatter graph you wish to insert.
4. A blank area should be inserted and you should see new tabs as options on the menu bar. Click the 'Design' tab and choose 'Select Data.' Hold 'Shift' while selecting the data and click 'OK' in the pop-up window.
5. Click on the 'Layout' tab and select 'Error Bars.' Select 'Error Bars with Standard Deviation' from the drop-down window.