Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Changing Chart Labels

A legend is a set of text labels that helps the reader connect the colors and patterns in a chart with the data they represent. Legend text is derived from the data series plotted within a chart. You can rename an item within a legend by changing the text in the data series. If the legend chart location doesn’t work with the chart type, you can reposition the legend at the right, left, top or bottom of the chart or overlay the legend on top of the chart on the right or left side. Data labels show data values in the chart to make it easier for the reader to see, while a Data table shows the data values in an associated table next to the chart. If you want a customized look, you can set individual options using the Format dialog box.

Change the Chart Legend, Labels, and Other Options

  • yellow-circle-01.gif Select the chart you want to modify.

  • yellow-circle-02.gif Click the Chart Options panel to expand it.
  • yellow-circle-03.gif Click any of the following buttons to show axis: Primary Vertical Axis, Primary Horizontal Axis, Depth Axis, Secondary Vertical Axis, and Secondary Horizontal Axis.
  • yellow-circle-04.gif Click any of the buttons for the major and minor gridlines.
  • yellow-circle-05.gif Click Labels drop-down, and then click one of the following:

    • None to hide the labels on the chart elements.
    • Value to display labels on the vertical axis chart elements.
    • Category Name to display labels on the horizontal axis chart elements.
  • yellow-circle-06.gif Click Legend drop-down, and then click one of the following: None, Bottom, Top Right, Top, Right, and Left.

  • + Share This
  • 🔖 Save To Your Account