From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Add error bars, lines, and up-down bars

Add error bars, lines, and up-down bars

From the course: Excel: Charts in Depth

Start my 1-month free trial

Add error bars, lines, and up-down bars

“

- [Instructor] A chart element type that's not widely used, but yet has an almost analytical role to play as we work with certain kinds of charts, is what we call an error bar. And we're looking at a worksheet called error bars for chapter three exercise file. I've got a line chart here. Error bars work with line and area charts as well as column bar charts and a few others. But many, we can't use the feature at all. Selecting this chart, go into Chart Design, in the ribbon, off to the left, Add Chart Element, Error Bars. You'll see some choices. We can make a choice here, and we'll choose percentage. And I would want to change that, you might too. Going back into Add Chart Element, back to Error Bars, How about More Error Bar Options and off to the right it activates the Format Error Bars dialog box. You might want to change that percentage to be maybe 25, I'm changing it off to the right there. And as I press…

Contents