Choosing the Right Chart for Your Data

A customer recently sent me their data for length of stay by surgeon.
They had run the data as a histogram, but wanted to know how to add the surgeon's names to length of stay.

histogram output

Choosing the Right Chart

I'm not sure why they choose a histogram. The most obvious chart for their data is a Pareto chart.

Pareto Chart output

QI Macros Chart Wizard

Years ago, I got tired of customers calling to ask: "Jay, what chart should I use?" Someone said: "I often find myself thinking, What Would Jay Do? So I created the QI Macros Chart Wizard to answer that question.

In this case, the user could have answered this question for themselves. If you're not sure what chart to choose, the QI Macros Chart Wizard will figure it out for you. Just select data with your mouse and click on the Chart Wizard.
In this case it would have automatically created a Pareto chart, not a histogram.

chart wizard


Let the QI Macros Wizards help you look super smart. Since I created them, I use them instead of trying to figure out what chart to choose. I let the wizards decide: What would Jay do?

Isn't it Time to Upgrade Your Excel Charting Skills?

Stop trying to make your spreadsheets easy to read. Nobody wants to read your spreadsheet!
And stop using primitive line, pie and bar charts.
Isn't it time to graduate to Smart Charts: Control Charts, Pareto charts and Histograms?

primitive charts
Primitive Charts
smart charts
Smart Charts

Stop Struggling with Excel Charts!
Start creating Smart Charts in just minutes.

Download a free 30-day trial. Get Smart Charts for Excel now!

Other Charts Included in QI Macros for Excel