If you look closely at the horizontal axis labels you will see that those labels do not match up with the labels that are in our data table. Add the proper labels from our data table to the chart Click the edit button under the horizontal axis table Click the collapse button in the axis label dialog box Then click your cursor in the starting cell for and drag “Baseline” it across all the way to the end cell will become the “Test”. These labels. Click the expand button to access the full menu. Click to finish adding the labels. “ok” And click to finish and close the dialog. “ok” Adding custom Standard Deviation error bars to a chart Select the first series you want to work with. Start with Group 1 so click the BLUE Line. Click the from the menu. “Layout” tab “Chart Tools” From the click the button. “analysis Group” “Error Bars” From the menu that appears, click the “More Error Bars Option”. From the menu that appears, click the button. “Custom” radio To tell Excel what numbers to use click the “Specify Value” button. To select the positive error value first click the collapse button. Then select the entire range of Standard Deviation that we calculated earlier for Group 1. Click the expand button to see the entire menu. Grab the same values for the negative errors value. Click the collapse button. Then select the entire range for SD that we calculated for Group 1. Click the expand button to access the full menu. Click ok to finish entering the custom error bar values.
If you look closely at the horizontal axis labels you will see that those labels do not match up with the labels that are in our data table. Add the proper labels from our data table to the chart Click the edit button under the horizontal axis table Click the collapse button in the axis label dialog box Then click your cursor in the starting cell for “Baseline” and drag it across all the way to the end cell “Test”. These will become the labels. Click the expand button to access the full menu. Click “ok” to finish adding the labels. And click “ok” to finish and close the dialog. Adding custom Standard Deviation error bars to a chart Select the first series you want to work with. Start with Group 1 so click the BLUE Line. Click the “Layout” tab from the “Chart Tools” menu. From the “analysis Group” click the “Error Bars” button. From the menu that appears, click the “More Error Bars Option”. From the menu that appears, click the “Custom” radio button. To tell Excel what numbers to use click the “Specify Value” button. To select the positive error value first click the collapse button. Then select the entire range of Standard Deviation that we calculated earlier for Group 1. Click the expand button to see the entire menu. Grab the same values for the negative errors value. Click the collapse button. Then select the entire range for SD that we calculated for Group 1. Click the expand button to access the full menu. Click ok to finish entering the custom error bar values.