From the course: Excel: Charts in Depth

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Box and whisker chart

Box and whisker chart

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

Box and whisker chart

“

- [Man] We're looking at a worksheet called box and whisker. This is on our chapter seven exercise file. That's an unusual name, but it's a valuable chart. And on this worksheet, we see data in columns A, B, and C. We've got sales persons in four major states here. And they're sorted by I.D. number. The statistics we see in columns E through I are valuable. We don't truly need these here, but it's going to help us explain how to read a box and whisker chart. We'll click within the data over in the left hand side. It is surrounded by empty cells, so we don't have to highlight it. And we'll simply, on the insert tab, go to the histogram icon, this is a statistical type cart, and there's box and whisker. We see the preview below. Use this chart type to display variation within a set of data. And because I do have the data up there, I want to line up these images with the data above. And again, I remind us, and…

Contents