Monday, October 2, 2017

Add axis titles to a chart

Add axis titles to a chart

After you create a chart, you can add axis titles to the horizontal and vertical axes in charts that have axes. You can't add them to charts that don't have axes such as pie and doughnut charts.

Much like a chart title you can add, axis titles help the people who view the chart understand what the data is about..

Stached Column chart with axis titles

Here's how you add axis titles:

  1. Make sure you're working in Excel Online edit mode.

    If you're in view mode, click Edit Workbook > Edit in Excel Online.

    Edit in Excel Online on the Edit Workbook menu

  2. Click anywhere in the chart to show the Chart Tools on the ribbon.

    Chart tab under Chart Tools

  3. Click Chart > Axis Titles.

    Axis Titles button on the Chart tab

  4. Click Primary Horizontal Axis Title or Primary Vertical Axis Title.

    Primary horizontal and vertical axis title options

  5. Do one of the following:

    • If you clicked Primary Horizontal Axis Title, pick Title Below Axis.

      Horizontal axis title options

    • If you clicked Primary Vertical Axis Title, pick Rotated Title, Vertical Title, or Horizontal Title.

      Vertical axis title options

  6. In the Title text box, type a title for the axis.

    To start a new line in the title, press Enter.

Edit Title box

Edit or remove axis titles

You can change the axis titles or remove them from the chart.

  1. Click anywhere in the chart to show the Chart Tools.

  2. Click Chart > Axis Titles > Primary Horizontal Axis or Primary Vertical Axis Title.

  3. Do one of the following:

    • To change the title, click Edit Horizontal Axis Title or Edit Vertical Axis Title and edit the text in the Title text box.

    • To remove the title, click None.

No comments:

Post a Comment