Home » Free Excel Tips » No One Can Read Your Excel Spreadsheet

No One Can Read an Excel Spreadsheet

So Stop Trying to Make Them Pretty!
Put Your Data in a Column and Draw a Smart Chart!

CPAs and Finance folks can read a spreadsheet; no one else. But I keep seeing people try to make their spreadsheets "pretty" as if they can be read and understood. Nonsense. Too many spreadsheets look like this data about patient falls per 1000 patient days:

What can we make of this data? Is May a really good month? Is July really bad? We don't know.

Having the data all split up like this makes it impossible to chart this data as a smart control chart. You will have to put it back into a single column to chart it:

Does the spreadsheet or chart give us more information about a hospital's performance regarding patient falls? The chart of course! The process is stable and predictably delivers 5.82 falls per 1000 patient days with a variation of ∓ 3.73.

Please stop trying to create "readable" spreadsheets. No one can read them or learn anything useful from them. Put your data in a column and chart the results—control charts for time series data and column or Pareto charts for categories. Use histograms to show the spread of data.

It's too easy with QI Macros. So why don't more people do it? Laziness? Fear?
Just do it. You'll be surprised how much more insight and discussion comes from a good chart rather than an unreadable spreadsheet.

---

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?