Chart elements (title, legend, axis labels) in Excel - Step-by-Step Guide

Introduction

Chart elements like titles, legends, and axis labels help explain what your chart shows. They make your chart easier to understand by adding clear descriptions and guides.

When you want to add a clear title to explain what your chart is about.

When your chart has multiple data series and you need a legend to identify each one.

When you want to label the horizontal or vertical axis to show what the numbers or categories mean.

When sharing reports so others can quickly understand the chart without guessing.

When preparing presentations to make charts look professional and clear.

Steps

Step 1: Click

- the chart to select it

Chart Tools tabs (Chart Design and Format) appear on the ribbon

Step 2: Click

- Chart Design tab on the ribbon

Chart Design options are shown

Step 3: Click

- Add Chart Element button in the Chart Layouts group

A dropdown menu with chart element options appears

Step 4: Select

- Title > Above Chart

A chart title box appears above the chart

💡 Click the title box to type your own title

Step 5: Select

- Legend > Right

A legend appears on the right side of the chart showing data series names

Step 6: Select

- Axis Titles > Primary Horizontal

A text box appears below the horizontal axis for labeling

Step 7: Click

- the axis title box and type your label

The axis label updates with your text

Before vs After

Before

Chart shows data bars with no title, no legend, and no axis labels

After

Chart has a clear title above, a legend on the right, and labels on both horizontal and vertical axes

Settings Reference

Chart Title

📍 Chart Design tab > Add Chart Element > Title

Adds or removes the chart title and controls its position

Default: None

Legend

📍 Chart Design tab > Add Chart Element > Legend

Shows or hides the legend and sets its position

Default: Right

Axis Titles

📍 Chart Design tab > Add Chart Element > Axis Titles

Adds labels to the horizontal and vertical axes

Default: None

Common Mistakes

Not selecting the chart before trying to add elements

Chart Tools tabs do not appear, so you cannot add or edit chart elements

Click the chart first to activate Chart Tools, then add elements

Typing axis labels outside the axis title boxes

Labels won't move with the chart and may not be clear or aligned

Use Add Chart Element > Axis Titles to add proper axis labels inside the chart

Leaving the legend off when multiple data series exist

Viewers cannot tell which color or pattern matches which data series

Always add a legend when your chart has more than one data series

Summary

Chart elements like titles, legends, and axis labels explain your chart clearly.

Use the Chart Design tab and Add Chart Element button to add or remove these elements.

Always select the chart first to access these options and make your chart easy to understand.