Adding a chart title takes three clicks

Open your chart by double-clicking it. Right-click the chart area and select Add Chart Element, then Chart Title, then Above Chart. Excel inserts a text box labeled "Chart Title" at the top. Click the text box and type what you want the title to say.

If you are working in Excel Online instead of the desktop version, the process is slightly different: click the chart once to select it, then click the paintbrush icon in the toolbar, expand Chart Title, and toggle it on. The title appears automatically and you can edit it by clicking directly on the text.

The title you add is separate from the chart itself, so you can move it, delete it, or change the text without affecting your data or the chart's shape. Most people put the title above the chart, but Excel lets you place it to the side or inside the chart area if that fits your layout better.

Key Takeaways

  • Double-click the chart, right-click inside it, and choose Add Chart Element > Chart Title > Above Chart to insert a title in three steps.
  • You can edit the title text by clicking on it after it appears, and move it anywhere on the chart by dragging.
  • Formatting options like font size, color, and bold are available by right-clicking the title text box and selecting Format Chart Title.
  • A chart title should describe what the chart shows in plain language so anyone reading the spreadsheet understands the data at a glance.

Where the title appears and how to move it

By default, Excel places the title above the chart. If you want it elsewhere, click the title text box and drag it to a new position — you can place it below the chart, to the left, to the right, or even overlaid on the chart itself if space is tight.

To change where the title sits without dragging it manually, right-click the title and select Format Chart Title. In the panel that opens, look for Title Options and choose Position. You will see radio buttons for Above Chart, Below Chart, Overlay, and other positions depending on your chart type.

If you delete the title by accident, you can add it back the same way you added it the first time: double-click the chart, right-click, and select Add Chart Element > Chart Title.

Changing the title's appearance

Right-click the title text box and select Format Chart Title to open the formatting panel. From here you can change the font, size, color, and weight (bold, italic, underline). You can also add a background fill, border, or shadow if you want the title to stand out.

The most common changes are increasing the font size so the title is straightforward to read from a distance, and making it bold to separate it visually from the chart itself. If your spreadsheet uses a company color scheme, you can match the title color to your brand by clicking the font color dropdown and selecting a custom color.

These formatting changes affect only the title, not the data labels, axis labels, or legend. Each of those has its own formatting options if you want to adjust them separately.

Writing a title that explains what the chart shows

A good chart title tells the reader what data is being displayed and, often, what time period or category it covers. Instead of "Sales," write "Monthly Sales by Region, 2024." Instead of "Temperature," write "Average Daily Temperature, January to March."

Keep the title short enough to fit on one line if possible, but not so short that it leaves the reader guessing. If your chart compares two groups or shows a trend over time, mention that in the title so the reader knows what to look for.

Avoid titles that are questions ("Are Sales Up?") or that state an obvious conclusion ("Sales Increased"). Let the chart speak for itself and use the title to identify what is being measured.

Titles for different chart types

A title works the same way on a bar chart, line chart, pie chart, or scatter plot — the steps to add and format it are identical. However, the kind of title that makes sense changes depending on what the chart shows.

For a pie chart showing how a budget breaks down, a title like "2024 Operating Budget by Department" tells the reader what the slices represent. For a line chart tracking stock price over time, "ABC Corp Stock Price, Last 12 Months" is clearer than just "Stock Price." For a bar chart comparing performance across regions, "Q4 Revenue by Region" is more useful than "Revenue."

The rule is the same for all: the title should answer the question "What am I looking at?" in as few words as possible.

Removing or hiding a chart title

If you decide you do not want a title, right-click it and select Delete. The title disappears and the chart expands slightly to fill the space.

Alternatively, you can hide the title without deleting it: double-click the chart, right-click the title, select Format Chart Title, and in the panel that opens, look for Title Options and toggle the title off. This keeps your formatting choices in case you want to show the title again later.

If you are sharing the chart with others and want to remove the title temporarily to see how the chart looks without it, hiding is faster than deleting and re-adding.

Titles when you copy or move a chart

When you copy a chart from one place to another in the same spreadsheet or to a different spreadsheet, the title comes along with it. You do not have to re-add it or reformat it.

If you copy a chart to PowerPoint or Word, the title travels with it as well, and you can still edit it in those programs using the same right-click method. The title remains linked to the chart data if the chart is embedded, so if the underlying numbers change, the chart updates but the title stays the same unless you edit it manually.

Frequently Asked Questions

Can I use a cell reference for the chart title instead of typing it in?

Yes. Right-click the title, select Format Chart Title, and in the panel look for a formula bar or text input field. Type an equals sign followed by the cell address, like =A1, and the title will pull its text from that cell. If you change the text in cell A1, the chart title updates automatically.

Why does my chart title look cut off or too small?

The title may be too long for the space available, or the font size may be too small to read. Try reducing the title text to fewer words, increasing the font size, or moving the title below the chart to give it more horizontal room. You can also make the chart itself larger by dragging its border.

How do I add a subtitle or secondary title to a chart?

Excel does not have a built-in subtitle feature, but you can add a text box above or below the main title and type additional information there. Click Insert > Text Box, draw the box near your chart, and type the subtitle text. Format it separately from the main title.

Does the title change if I update the data in my chart?

No, the title stays the same unless you edit it manually or link it to a cell. If you change the numbers in your chart, the chart itself updates but the title does not. This is usually what you want, since the title describes what the chart measures, not the specific values.

Can I rotate or angle the chart title?

Yes. Right-click the title, select Format Chart Title, and look for Text Options or Alignment. You will find a rotation setting where you can angle the text. Most people leave the title horizontal, but rotating it can help fit a long title in a narrow space.