Error Bars in Microsoft® Excel® 2003
Are you curious to know about error bars in Microsoft Excel 2003 and want tips to add or remove them?
The error bar is a useful and flexible tool that helps in adding details to an Excel chart. A typical use for error bars is to show variability in the measure which are plotted in chart. The error bars express potential error amount that are graphically relative to each data market or data point in a data series. You can add error bars to data series in a 2D area, column, XY (scatter), bar, line and bubble charts. You can display error bars for the y values, the x values or both. You can remove error bars immediately after you add them to the chart by clicking 'Undo' on the quick access Toolbar or by pressing 'CTRL + Z'.
The following are the some of the tips to add or remove error bars in Microsoft Excel 2003:
- Add error bars
- Remove error bars
- Error bar tricks
Add error bars
You can add error bars in 2-D area, bar, column, line, XY (scatter) and bubble chart. To add error bars to a selected data series or data point, click the point or data series that you want. The error bars are easy to add to a chart series, you have to double click on series or select the series and press 'CTRL + 1'.
Remove error bars
First, you have to click anywhere in the chart. It will display the chart tools. On the 'Format' tab, in the current selection group, select the arrow next to the Chart Element box and click the Chart Element that you want. On the 'Layout' tab in the Analysis group, select 'Error bars' and then click 'None' and press 'Delete'.
You can drop the lines from each point to the axis using negative error bars with a percentage value of 100%. The error bars provide one mechanism to add horizontal or vertical lines to a column or line chart. The Gridlines are simply a set of horizontal or vertical lines. You can use the error bars to construct a step chart, using subtraction formulas to compute the error bar lengths. You can delete either of these error bars by selecting them, and then pressing 'Delete'.