From the course: Excel 2016: 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.
Histogram chart
- Another new chart type in Excel 2016 is called a histogram. Now, you could've created this in prior versions using the frequency function. You would've needed to have set up what's called a bin range to represent some breakpoints to show how many salaries we have between, for example, between 20 and 40,000, 40 and 60,000, something like that. We don't have to do any of that work here. For reference, I have put in two functions in cells D1 and E1, showing us the maximum value found in column B and the minimum value. So all the salaries range between those two numbers. So selecting column B only then going to the Insert tab, the histogram option is the middle of the nine buttons that we see here in the Charts group right there, Histogram, and immediately we see a histogram and the description, "Use this chart type to show "the distribution of data grouped into bins." We'll see that term in a minute. I'm going to make this a bit wider. We see the numbers at the bottom. They're not…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.