Tuesday, May 21, 2013

How to Insert Error Bars in Excel 2007


1. Open the Microsoft Excel 2007 application that contains the chart that you want to add error bars to.
2. Click on the area of the chart where you want to add the error bars. Click on the “Format” tab and then click on the arrow next to the “Chart Elements” box.
3. Click on the chart element from the list that you want to add the error bars to. Click on the “Layout” tab and then click on the “Error Bars” option from the “Analysis” group.
4. Select the “Error Bars with Standard Error”, “Error Bars with Percentage” or “Error Bars with Standard Deviation” option.
5. Click on the “More Error Bar Options” button and then click on the “Vertical Error Bars” or “Horizontal Error Bars” option.
6. Click on the “OK” button and the type of error bars you selected will appear on your chart.

Blogger news