Why you should expunge the defaults from Excel or (insert your favorite graphing program)
Sep 25, 2020
Yesterday, I posted the following chart in the post about Cornell's Covid-19 case rate after re-opening for in-person instruction.
This is an edited version of the chart used in Peter Frazier's presentation.
The original chart carries with it the burden of Excel defaults.
What did I change and why?
I switched away from the default color scheme, which ignores the relationships between the two lines. In particular, the key comparison on this chart should be the actual case rate versus the nominal case rate. In addition, the three lines at the top are related as they all come from the same underlying mathematical model. I used the same color but different shades.
Also, instead of placing the legend as far away from the data labels as possible, I moved the line labels next to the data labels.
Instead of daily date labels, I moved to weekly labels, and set the month names on a separate level than the day names.
The dots were removed from the top three lines but I'd have retained them, perhaps with some level of transparency, if I spent more time making the edits. I'd definitely keep the last dot to make it clear that the blue lines contain one extra dot.
Every graphing program has defaults, typically computed by some algorithm tuned to the average chart. Don't settle for the average chart. Get rid of any default setting that slows down understanding.
Do you insert text boxes instead of the default legend?
Posted by: Dave C. | Sep 25, 2020 at 12:56 PM
DC: For this post, I just made the changes in Powerpoint. But you can do this in Excel, esp. if you want to do this repeatedly. Just make a fake data point at the end of each line, add the line label as a data label, then white out the dot and line segment. I cover this and other Excel tricks in one of my corporate training classes - many of these edits are annoying but they can be done, and the chart becomes more readable.
Posted by: Kaiser | Sep 25, 2020 at 11:23 PM