How To Change Legend Labels 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. |
Costless Quick Reference
Click to Download
Free to distribute with our compliments; we hope you volition consider our paid grooming.
Source: https://www.customguide.com/excel/how-to-edit-legend-in-excel
Posted by: wilsonnoweed.blogspot.com
0 Response to "How To Change Legend Labels In Excel"
Post a Comment