From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

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

Histograms and Pareto charts

Histograms and Pareto charts - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Histograms and Pareto charts

“

- [Instructor] The next types of charts that we'll dive into are histograms and Pareto charts. They sound super fancy, but trust me, they're not that complicated. The one thing I will preface is that histograms look a whole lot like column charts, but they're very, very different. So don't confuse the two. Column charts are designed to show volume. Histograms are designed to show frequencies. So along the x-axis of a histogram, rather than having category labels you've got bins or ranges of values where the height of the rectangle associated with those bins indicate the number of observations that fall within those ranges. A Pareto chart is just a slight variation of a histogram where the bins are reorganized from highest frequency to low, and a line is overlaid showing the total cumulative frequency. So these charts are commonly used for showing the distribution of a continuous data set. It's great for showing things like the frequency of test scores among a student group or a…

Contents