Home > Articles > Programming > General Programming/Other Languages

This chapter is from the book

Changing the Chart Layout Objects

PP07S-3.6.4

The layout of a chart typically comes with a chart title, axis titles, data labels, and a legend. However, you can also include other elements, such as data labels, and a data table. You can show, hide, or change the positions chart elements to achieve the look you want. You can also change the chart display by showing axis or gridlines with different measurements. Format the background of a chart by showing or hiding the chart wall or floor with a default color fill, or by changing the 3-D view of a chart.

Change Chart Labels

1.gif Select the chart or a chart element you want to change.

2.gif Click the Layout tab under Chart Tools.

3.gif Click any of the following buttons:

  • Chart Title to show, hide, or position the chart title.
  • Axis Title to show, hide, or position the text used to label each axis.
  • Legend to show, hide, overlay, or position the chart legend.
  • Data Labels to add, remove, or position data labels.
  • Data Table to add a data table to the chart.

Change Chart Axis

1.gif Select the chart or a chart element you want to change.

2.gif Click the Layout tab under Chart Tools.

3.gif Click any of the following buttons:

  • Axis to change the formatting and layout of each axis.
  • Gridlines to show or hide major or minor gridlines.

4.gif If necessary, select the options you want, and then click Close.

Change Chart Background

1.gif Select the chart or a chart element you want to change.

2.gif Click the Layout tab under Chart Tools.

3.gif Click any of the following buttons:

  • Plot Area to show or hide the plot area.
  • Chart Wall to show or hide the chart wall with the default color fill.
  • Chart Floor to show or hide the chart floor with the default color fill.
  • 3-D View to change the 3-D viewpoint of the chart.
  • + Share This
  • 🔖 Save To Your Account