Utah Community Learning

Bar vs line vs pie, and picking the right one

Okay sooo. Last lesson we made our first chart. This lesson is about making the RIGHT chart, which is a different skill and honestly the more important one.

Here's the thing. Excel and Sheets will let you make basically any chart with any data. It does not check whether that chart makes sense. It'll happily build you a pie chart out of data that has no business being a pie chart, and it will look fine, and it will explain nothing. So the tool isn't going to save you here. You have to know what you're looking at.

The three you actually need

There are like fifteen chart types in that menu. Ignore almost all of them. For everyday spreadsheet stuff, you need three.

Bar chart. Comparing separate things to each other. Groceries vs gas vs subscriptions. Category A vs category B. If your question is "which one is bigger," it's a bar chart.

Line chart. Change over time. Spending by month, savings going up, weight going down, whatever. If your question has the word "trend" hiding in it, it's a line chart.

Pie chart. Parts of a whole, and only when there aren't too many parts. Five slices, fine. Twelve slices, it turns into confetti and nobody can read it. I'm not a huge pie chart person in general, not gonna lie, but they're the right call sometimes.

That's really it. Notice none of these is "which chart looks the coolest." That's not a category.

How to actually pick

Ask yourself one question before you touch the chart button: what am I trying to show, in one sentence?

Not "I want to chart my spending." Too broad. More like:

"I want to show which category eats the most money." → bar.
"I want to show if I'm spending more now than six months ago." → line.
"I want to show how my paycheck splits up." → pie, if you kept it to your five or six categories like we talked about back in the budget lessons.

If you can't finish that sentence, you're not ready to make the chart yet. Go figure out the sentence first. This is the same thing I always say about spreadsheets in general, most people don't actually have a spreadsheet problem, they have a question problem. Charts are just that, but louder.

A story on this, because I learned it the hard way

I spent an entire Saturday once building a chart to show our grocery spending by month. Not a quick thing, I mean I fussed with it. Colors, labels, got the axis just right. Felt very proud of myself, showed Casey like I'd made him a gift.

He looked at it for about four seconds and said "okay so we spend a lot in December."

And I said yes. That's the chart working.

That's genuinely the whole point. I wanted him to look at it and immediately know the one thing without me explaining anything. He did. It wasn't exciting, it wasn't a whole analysis, it was one boring obvious fact landing in four seconds. Boring and obvious is the win. If he'd had to squint and ask me three follow-up questions, I would have built the wrong chart.

Making the call, step by step

Write your one sentence first. Actually type it in a cell above the chart if you need to, doesn't have to be permanent.
Match it to bar, line, or pie using the list above.
Select just the data you need. Not the whole sheet, not extra columns you're not using. Extra data confuses the chart and confuses you.
Insert your chart type. In Sheets it's Insert, then Chart. In Excel it's the Insert tab, then the chart icons, though not gonna lie I sometimes hit the wrong one because I bounce between the two programs. If I fumble it live in class, that's why.
Look at it with fresh eyes. Could a stranger read your one sentence off this chart in five seconds? If not, something's off, usually too many categories or too many months crammed in.

The mistake I see most

People try to cram everything into one chart. All twelve months, all six categories, three chart types fighting each other. It ends up needing a paragraph of explanation next to it, and at that point it's not a chart anymore, it's a puzzle. One chart, one idea. If you've got five things you want to show, make five small charts, not one loud one.

Also a small practical note. Pie charts with a lot of thin slices are genuinely hard to read on a screen, especially if a few categories are small. If more than one or two slices are tiny slivers, that's your sign to switch to a bar chart instead, or to lump the small stuff into an "other" category.

Before next time

Pick one question you actually want answered from your tracking sheet, write it as one sentence, and make the chart that answers it. If you catch yourself reaching for a pie chart with eight slices, that's your cue to stop and pick differently.