← All Kits · Excel Kit

Chart Titles That Say the Finding, Not the Contents

Michael Nocito · Updated August 2026 · Every number on this page was worked before it was published

Most chart titles are filing labels. Revenue by Region. Tickets over Time. Headcount by Department. They say what the ingredients are and leave the reader to do the analysis in their head, standing up, in a meeting, in about two seconds.

What you do: put the finding in the title, the scope in the subtitle, and the source in a footnote. Three lines, always in the same places.

The short version. If your title would still be accurate after the data changed, it is not saying anything.

The three-part block

The order matters because it matches how people read: the claim first, the qualification second, the provenance only if they doubt it. Putting the scope in the title is the most common near-miss. "Revenue by Region, FY26, excluding intercompany" is precise and still tells nobody anything.

Eight titles, rewritten

Each rewrite does the same three things: it names the direction, attaches a number, and points at one thing rather than the whole chart. The last one is the discipline people skip. A title that summarises everything on the chart is back to being a label.

When the title must stay neutral

Two situations, and they are real.

Interactive or filtered views. If the reader can change the region and the date range, any finding you hard-code is wrong for most of the states the chart can be in. Use a neutral title and put the live finding in a dynamic subtitle if your tool supports it. In Excel, a title linked to a cell does this: click the chart title, type =, click a cell holding a formula-built sentence.

Reference and monitoring views. A control chart that ten teams check daily for ten different reasons should not be pre-interpreted by whoever built it. Neutral title, and a subtitle that explains how to read the chart rather than what to conclude.

Outside those two, a neutral title is usually not neutrality. It is the analysis not being finished.

Writing the sentence

1. Look at the chart and say out loud what you see. That sentence is the draft.
2. Cut it to under about twelve words, keeping the number.
3. Check it is falsifiable. "Sales performance was mixed" survives any data and is therefore not a finding.
4. Check the chart supports it. A title claiming causation over a chart showing two lines is the failure in correlation vs causation, printed in bold at the top.
5. Move everything else into the subtitle.

Doing it in Excel

1. Click the chart title, type =, then click the cell containing your sentence. The title now updates when the data does.
2. Build the sentence with a formula so the numbers cannot go stale: ="West grew "&TEXT(D5,"0%")&" while East fell "&TEXT(D7,"0%").
3. For the subtitle, use a text box anchored under the title, or a second linked cell, since Excel gives a chart only one title object.
4. Left align both. Centred titles fight with the plot area and are harder to scan down a page of charts.

How to apply this to your own work

1. Open your last deck and count the titles that name ingredients. That count is your backlog.
2. Rewrite the three most important ones today. The front chart of a pack is worth more than the other nine put together.
3. Add a subtitle line to each rewritten chart carrying the scope you just removed from the title.
4. Link one title to a cell so it maintains itself, and see whether you trust it enough to do the rest.
5. Ask a colleague to read only the titles of your deck. What they can tell you back is what your deck actually says.

The one habit to keep

Write the title before you format anything. If you cannot write the finding, the chart is not finished, and no amount of colour work will finish it.

Could someone read only the titles in your last pack and come away with the story?