Use a screen reader to add a title, data labels, and a legend to a chart in Excel 2016

You can use a keyboard and screen reader to add a title, data labels, and a legend to a chart in Excel 2016. Titles, data labels, and legends help make a chart accessible because they provide non-visual elements that describe the chart.

Notes: 

In this topic

Add a title to a chart

Titles help people to quickly grasp the information represented in a chart. For example, in your monthly budget worksheet, when you create a Pie chart of actual costs per expense category, titling the chart Actual Cost can make the chart easier to understand. And when you create a Bar chart of the projected costs per expense category in that worksheet, titling the axes Expense category and Projected cost can make the chart more accessible.

  1. Select the chart that you want to work with.

  2. To open the Add Chart Element menu, press Alt, J+C, and then A.

  3. On the menu, select the type of title you want to add.

    • To add a chart title, press C. The focus moves to the Chart title edit box.

      • To add a title above the chart, press A, type a title, and then press Enter.

      • To add a centered overlay title, press C, type a title, and then press Enter.

      • To browse more title options, press M and then use the Down Arrow key.

    • To add axis titles, press A. (Charts that don’t have axes, such as Pie or Doughnut charts, won’t have axis titles.)

      • To add a primary horizontal axis title, press H. The focus moves to the Primary Horizontal Axis Title edit box. Type a title, and press Enter.

      • To add a primary vertical horizontal axis title, press V. The focus moves to the Primary Vertical Axis Title edit box. Type a title, and press Enter.

      • To browse more axis title options, press M and then use the Down Arrow key.

    The titles you entered are added to your chart.

Notes: 

  • To remove a chart title, press Alt, J+C, A, C, and then N.

  • To remove a primary horizontal axis title, press Alt, J+C, A, and then H.

  • To remove a primary vertical axis title, press Alt, J+C, A, and then V.

Add data labels to a chart

Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in your monthly budget worksheet, when you create a Pie chart of actual costs per expense category, without data labels it might be difficult to tell that groceries were 19 percent of your total budget.

  1. Select the chart that you want to work with.

  2. To select the Add Chart Element button, press Alt, J+C, and then A.

  3. To open the Data Labels menu, press D.

  4. On the menu, select the type of labels you want to add:

    • To select Center, press C.

    • To select Inside End, press E.

    • To select Inside Base, press B.

    • To select Outside End, press O.

    • To select Data Callout, press U.

    • To browse more Data Label options, press M and then use the Down Arrow key.

    The data labels you selected are automatically added to your chart.

Note: To remove data labels, press Alt, J+C, D, and then N.

Add a legend to a chart

Legends help you to quickly understand data relationships in a chart. For example, in your monthly budget worksheet, when you create a Bar chart comparing projected costs with actual costs per expense category, a legend helps you to quickly identify the two different bars and to identify the categories with the greatest discrepancies.

  1. Select the chart that you want to work with.

  2. To select the Add Chart Element button, press Alt, J+C, and then A.

  3. To open the Legend menu, press L.

  4. On the menu, select where you want to add the legend:

    • To select Right, press R.

    • To select Top, press T.

    • To select Left, press L.

    • To select Bottom, press B.

    • To browse more Legend options, press M and then use the Down Arrow key.

    The legend is automatically added to your chart in the selected location.

Note: To remove a legend, press Alt, J+C, A, L, and then N.

More information

Keyboard shortcuts in Excel 2016 for Windows

Use a screen reader to create a chart and select a chart in Excel 2016

Use a screen reader to insert a table in an Excel 2016 worksheet

Checklist: Create accessible spreadsheets in Excel 2016

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×