How To Change Legend Labels In Excel

How to Edit a Legend in Excel

Besides using built-in chart layouts, you tin manually add together or edit private chart labels such as the chart title or axis titles.

Alter the Chart Championship

The nautical chart title oft appears to a higher place the nautical chart and is used to describe the data that's being presented. You can add a completely new chart title or merely alter the text of an existing one.

Select the nautical chart.
Right-click the chart title.
Click the Edit Text button.

Double-click the chart title to get in editable.
Enter the new chart title.
Click anywhere exterior the championship area.

Add together Axis Titles

The axis titles draw for viewers the category of data that's existence represented. Without them, it can be difficult to accurately portray information.

Select the nautical chart
Click the Chart Elements button.
Hover the mouse over the characterization options in the listing to preview them on your chart before making your pick.
Select the Axis Titles check box.
A text box is added for both the vertical and horizontal axes.
Enter descriptive axis titles.
Click outside the championship surface area.

Position the Chart Fable

Usually when a chart is created, a legend is added automatically. The fable identifies what data is portrayed in the chart's plot expanse.

Select the nautical chart
Click the Chart Elements button.
Click the Legend button.
Be conscientious not to click the word "Legend" or it will turn it off, only hover over it until the list arrow appears.
Select a position for the legend.

You tin can also click the Add together Chart Element button on the Blueprint tab.

Chart Elements

Chart and axis titles are merely a couple of the chart elements that are customizable. This table describes everything you tin can modify.

Chart Element	Description
Axes	Identifies the values beingness charted. Most charts have a vertical and horizontal centrality.
Centrality Titles	Provides a descriptive characterization for the data being charted on the axis.
Nautical chart Title	Describes the data being presented in a chart.
Data Labels	Displays data from the cells of the worksheet on the plot area of the chart.
Data Table	A tabular array added adjacent to the chart that shows the worksheet information the chart is illustrating.
Fault Bars	Helps you lot quickly identify standard deviations and error margins.
Gridlines	Horizontal and/or vertical lines added to a chart to brand data easier to read.
Legend	The chart'south key. Describes the data beingness presented in the plot surface area of the nautical chart.
Trendline	Identifies the tendency of the current data, non actual values. Can also identify forecasts for time to come information.