How to Customize Chart Titles and Legends in Excel
Besides using built-in chart layouts, you can manually add or edit individual chart labels such as the chart title or axis titles.
The chart title often appears above the chart and is used to describe the data that’s being presented. You can add a completely new chart title or simply change the text of an existing one.
Double-click the chart title to make it editable.
The axis titles describe for viewers the category of data that’s being represented. Without them, it can be difficult to accurately portray information.
Hover the mouse over the label options in the list to preview them on your chart before making your selection.
A text box is added for both the vertical and horizontal axes.
Usually when a chart is created, a legend is added automatically. The legend identifies what information is portrayed in the chart’s plot area.
Be careful not to click the word “Legend” or it will turn it off, just hover over it until the list arrow appears.
You can also click the Add Chart Element button on the Design tab.
Chart and axis titles are just a couple of the chart elements that are customizable. This table describes everything you can modify.