Charts & PivotTables · ~1 min read

Format Excel Charts Like a Pro (Titles, Labels, Colors)

Titles, data labels, axes, colors and templates.

Video link coming soon
What you will learn

Step by step

1. Default to pro

A default chart works, but nobody reads it. Four quick changes turn it into a chart people understand at a glance.

A real title, numbers on the bars, less clutter, and a calmer style.

Format Excel Charts Like a Pro (Titles, Labels, Colors): Default to pro
Default to pro

2. Title

Start with the title. Chart Title says nothing. Click it once, type Sales and costs, first half, and press Enter.

Format Excel Charts Like a Pro (Titles, Labels, Colors): Title
Title

3. Data labels

Next, the exact numbers. Click the plus button beside the chart. These are the chart elements.

Tick Data Labels. Every bar now shows its value, so nobody has to guess from the axis.

Format Excel Charts Like a Pro (Titles, Labels, Colors): Data labels
Data labels

4. Less clutter

With labels on, the gridlines are clutter. Untick Gridlines.

Quick pause: if your charts already look better, a like really helps the channel. Next comes the style, and then the trap.

Format Excel Charts Like a Pro (Titles, Labels, Colors): Less clutter
Less clutter

5. A calmer style

Now the look. With the chart selected, open Chart Design and pick a calmer style from the gallery.

Click any cell. Clear title, exact labels, no grid, a calm style. This chart reads in two seconds.

Format Excel Charts Like a Pro (Titles, Labels, Colors): A calmer style
A calmer style

6. The title trap

Now the trap. Change June's sales to three hundred. The bar and its label update by themselves.

But the title is typed text. If it should say a total or a month, it will never update. Link a title to a cell instead, and it changes with the data.

Format Excel Charts Like a Pro (Titles, Labels, Colors): The title trap
The title trap

7. Recap

Recap: a clear title, data labels, no gridlines, one calm style, and titles linked to cells when they show numbers.

In the next lesson, you will put tiny charts inside cells with sparklines.

What is the first thing you change on every new chart? Tell me in the comments.

Format Excel Charts Like a Pro (Titles, Labels, Colors): Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: How to Make a Chart in Excel (Column, Line, Pie)
Next tutorial: Excel Sparklines: Tiny Charts in a Cell →