Home > Articles > Computer Software > Business Office Software

This chapter is from the book

This chapter is from the book

Changing Chart Elements

The layout of a chart typically comes with a chart title, X and Y axes, axis titles, and a legend. However, you can also include other elements, such as data labels, a data table, gridlines. A legend is a set of 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 it. 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 a table next to the chart. To change elements, you can use the Add Chart Element button on the Design tab under Chart Tools or use the Chart Elements button (New!) (one of three) in the upper-right corner of the chart. If you want a customized look, you can double-click an element to set options using the Format pane (New!).

Change the Chart Elements

  • yellow-circle-01.jpg Select the chart you want to modify.
  • yellow-circle-02.jpg Click the Design tab under Chart Tools.
  • yellow-circle-03.jpg To quickly show or hide chart elements, click the Chart Elements button near the chart, and then select or clear the element check box (New!), or click an arrow, and then a command.
  • yellow-circle-04.jpg Click the Add Chart Element button (New!), and then point to one of the following options:

    • Axes to display the horizontal and vertical axes.
    • Axis Titles to display the horizontal and vertical axis titles.
    • Chart Tile to display or position the main chart title. Double-click the text box to modify text.
    • Data Labels to show or hide data labels.
    • Data Table to show or hide a data table along with the chart.
    • Gridlines to display different types of gridlines.
    • Legend to display or position the chart legend.
  • + Share This
  • 🔖 Save To Your Account