How to Add a Chart Title in Excel (And Customize It Your Way)
Adding a chart title in Excel takes seconds — but how you do it, and what you can do with it afterward, depends on which version of Excel you're using, whether you're working on desktop or web, and how much control you want over the final result.
Here's a full walkthrough of the process, plus everything that affects how chart titles behave across different setups.
Why Chart Titles Matter More Than They Seem
A chart without a title forces the reader to interpret what they're looking at from context alone. In reports, dashboards, or shared workbooks, that's a friction point. Excel treats the chart title as an object layer sitting above the plot area — it's not just decorative text, it's a named element you can format, link to a cell, or remove entirely depending on your needs.
How to Add a Chart Title in Excel (Desktop)
Method 1: Using the Chart Elements Button
This is the fastest route on Excel for Windows and Mac:
- Click anywhere on your chart to select it
- Look for the "+" (Chart Elements) button that appears to the right of the chart
- Check the "Chart Title" box
- A default title text box labeled "Chart Title" will appear above the chart
- Double-click the title text to edit it and type your own label
This method works in Excel 2013 and later, including Microsoft 365.
Method 2: Through the Chart Design Tab
If you prefer the ribbon:
- Click the chart to select it
- Go to the Chart Design tab (it appears in the ribbon when a chart is selected)
- Click "Add Chart Element" on the left side of the ribbon
- Hover over "Chart Title"
- Choose a position: Above Chart or Centered Overlay
Above Chart pushes the plot area down slightly to make room. Centered Overlay places the title on top of the chart without resizing the plot area — useful when space is tight, though readability can suffer.
Method 3: Older Excel Versions (2010 and Earlier)
In Excel 2010, the path is slightly different:
- Select the chart
- Go to the Layout tab (part of Chart Tools)
- Click Chart Title
- Select your preferred placement option
The Layout tab was replaced by Chart Design and Format tabs in Excel 2013, so if you don't see it, you're on a newer version.
How to Add a Chart Title in Excel for the Web
Excel Online has a simplified interface. Here's how it works:
- Click the chart
- Select the Chart tab in the ribbon
- Click "Add Chart Element"
- Choose Chart Title and your preferred position
⚠️ Some advanced formatting options available in the desktop app aren't available in the web version — things like text direction, detailed font effects, or linking the title to a cell reference.
Linking a Chart Title to a Cell
This is one of the most underused features in Excel charting. Instead of static text, you can make your chart title dynamically update based on cell content.
Here's how:
- Add a chart title using any method above
- Click once on the chart title to select it (a single click, not a double-click)
- In the formula bar at the top, type
=followed by the cell reference — for example,=Sheet1!$A$1 - Press Enter
Now whatever text is in that cell becomes the chart title. If you update the cell, the title updates automatically. This is especially useful in dynamic dashboards where chart titles need to reflect filtered data, selected dates, or changing categories.
Formatting Your Chart Title 📊
Once your title is in place, you have full formatting control:
- Double-click the title to enter edit mode and change the text
- Right-click the title and select "Format Chart Title" to open the formatting pane
- From there, you can adjust font size, color, alignment, border, fill, and text effects
You can also drag the title to reposition it manually if you don't want it locked to the default "above chart" position.
Removing a Chart Title
If you decide you don't want a title at all:
- Click the title once to select it, then press Delete
- Or go to Chart Design → Add Chart Element → Chart Title → None
Key Variables That Affect Your Experience
Not every Excel user encounters chart titles the same way. Several factors shape what's possible:
| Variable | How It Affects Chart Titles |
|---|---|
| Excel version | Layout tab (2010) vs. Chart Design tab (2013+) |
| Desktop vs. Web | Cell linking and advanced formatting only on desktop |
| Chart type | Some chart types (e.g., sparklines) don't support titles |
| Shared workbooks | Co-authoring in Microsoft 365 may limit real-time formatting |
| Mac vs. Windows | Minor UI differences, but core steps are the same |
When Static Titles Fall Short
For users building reports that refresh automatically — connected to Power Query, external data sources, or structured tables — a static chart title can quickly become outdated. That's where the cell-linking method becomes important rather than optional.
On the other hand, for a one-time chart in a simple spreadsheet, typing directly into the title box is perfectly sufficient. The right approach shifts depending on how the workbook will be used, who will update it, and whether the data underneath the chart is expected to change over time.
How much flexibility you actually need from your chart title depends entirely on what your workbook is doing — and that's a question only your specific setup can answer.