Adding error bars


show more Adding error bars provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Adding error bars

To show values above and/or below points in a chart series, you can insert what are called vertical error bars. They can be based on percentages or fixed values or even standard deviation calculations. And these work in line charts. We are probably more likely to see them here, but they also work in column and bar charts, also in scatter charts and bubble charts, but no other types. So in the lower chart here--and I think you'll find that these tend to work better when you are working only with the single series, although you can use multiple series.

In this lower chart, let's insert some error bars, so the chart has been selected. Then in the Layout tab in the Ribbon, in the Analysis Group, choose Error Bars, and you'll see some options here. Error Bars with Standard Deviation. Now of course, we'd have to know something about standard deviation to know what this really means here, but the bars that we see, and they are the same all the way across, represent the standard dev...

Adding error bars
Video duration: 3m 58s 3h 36m Intermediate

Viewers:

Adding error bars provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...