Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Changing Chart Labels

The layout of a chart typically comes with a chart title, axis titles, and a legend. However, you can also include other elements, such as data labels, and a data table. 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 Labels

  • yellow-circle1.jpg Select the chart you want to modify.
  • yellow-circle2.jpg Click the Layout tab under Chart Tools.
  • yellow-circle3.jpg Click any of the following in the Labels section of the Ribbon:
    • Chart Tile to display or position the main chart title. Double-click the text box to modify text.
    • Axis Titles to display the horizontal and vertical axis titles.
    • Legend to display or position the chart legend.
    • Data Labels to show or hide data labels.
    • Data Table to show or hide a data table along with the chart.
  • + Share This
  • 🔖 Save To Your Account