Cleaning up a chart so the point is obvious
Okay sooo. Last lesson we picked the right chart type for the job. Bar, line, or pie, matched to the question you're actually asking.
This lesson is about the part everybody skips. You make the chart, it technically shows your data, and it's still somehow confusing to look at. That's a cleanup problem, not a chart-type problem, and it's fixable in about five minutes once you know what to look for.
Here's the thing. A chart is supposed to make one point obvious at a glance. If someone has to squint at it and ask you what they're looking at, it's not doing its job yet, even if the underlying data is perfect.
Start by naming the one point
Before you touch any formatting, say out loud (or type in a cell somewhere) what the chart is supposed to prove. Something like "we spend way more in December than any other month." One sentence.
If you can't get it down to one sentence, that's not a formatting problem, that's a too-many-ideas problem, and no amount of cleanup fixes it. Split it into two charts instead.
The usual mess, and how to clear it
Kill the legend if you don't need it. If you've only got one series (one line, one set of bars), a legend is just wasted space telling you "this is the only thing here." Click it, hit delete. Excel and Sheets both let you label the data directly instead, which is cleaner.
Fix the title. "Chart 1" or "Sheet1!A1:B12" is not a title, that's a filing error. Double-click the title box and type the actual point. Not "Monthly Spending," but "December spending is way higher than every other month." Make the title do the work.
Turn off gridlines you don't need. Little bit, not all of them necessarily, but a chart covered in faint horizontal lines everywhere gets busy fast. Try turning off the vertical ones first and see if it reads easier.
Cut the decimal places. Nobody needs to see $342.17 on a bar label. Round it. Right-click the axis or the data labels, format as currency or number, set decimals to zero.
Reconsider your colors. If every bar is a different random color for no reason, that's noise. One color for most of the bars, and a second color ONLY on the bar you want to highlight, is a trick that works almost every time. Draws the eye exactly where you want it.
Look at your axis scale. This one bites people. If your spending ranges from $200 to $600 but your axis starts at zero and goes to $5,000, all your bars look nearly the same height and the real difference disappears. Adjust the axis minimum and maximum so the actual range of your data fills the chart.
A quick honesty check
Not gonna lie, I built a whole chart once, a really nice one, showing our grocery spending by month, and felt very proud of myself. Showed Casey. He looked at it for about two seconds and said "okay so we spend a lot in December." That's it. That's the whole insight.
And that's the point. That's the chart working. I wanted him to be impressed by the chart itself, and instead he just understood the point instantly and moved on with his day. A good chart isn't supposed to be admired, it's supposed to disappear and leave you with the fact.
A word about trusting what's in front of you
This is where I bring up the two weeks. Early in my very first real spreadsheet job, I had a formula pointing at the wrong column. Just one column off. It sat there wrong for two solid weeks and nobody caught it, me included, because the chart built off of it still looked reasonable. Nothing looked broken.
When I finally found it I went cold for a second, the way you do when you think you've messed something up badly. Then I actually checked what it changed, and it turned out the wrong numbers had been wrong in a way that didn't actually change the conclusion. I laughed out loud alone at my desk.
The lesson isn't "it always works out." The lesson is that a chart can look clean and confident and still be pointing at the wrong data underneath. Before you clean up formatting, double check the chart is actually pulling from the range you think it is. Click on it, look at the highlighted source range, make sure it matches what you meant. Takes ten seconds. Do it before you spend twenty minutes making a wrong chart pretty.
Try this at home
Pick a chart you already made, from the budget or the tracking sheet. Say the one-sentence point out loud. Then go through it: legend, title, decimals, colors, axis scale. See how much clearer it gets once you're only fighting for one idea instead of five.
Before next time: bring the chart you cleaned up, even a rough version. Next lesson we're going to talk about when a chart is the wrong tool entirely and a plain number is actually better.
- C