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

You can use a keyboard and a screen reader to a create chart in an Excel 2016 worksheet and to select a chart so you can work with it. When you create a chart, you can choose the chart type, style, orientation, and more. To make changes to an existing chart (for example, to modify the layout or to add a title, data labels, or alt text), you first select it.

Note: This topic assumes that JAWS users have the Virtual Ribbon Menu feature turned off.

In this topic

Create a basic chart

  1. Select the data you want to include in your chart. For example, to create a chart of expenses by category in your monthly budget worksheet, select the Category column and the Actual cost column.

    Tip: To quickly select a data range, name it. Screen readers read the name of the data range, which makes the information easier to select. For example, in your monthly budget worksheet, you could select the Category column and the Actual cost column and then name the range ActualCostByCategory. Refer to Use a screen reader to name a cell or data range in Excel 2016.

  2. To open the Insert tab, press Alt+N.

  3. Select a chart type:

    • To create a Column or Bar chart (to compare values across a few categories), press C. To select the type of Column or Bar chart, use the Down Arrow key and the Right Arrow key, and then press Enter.

      Tip: You can quickly insert a basic Bar chart in a worksheet. Select the data you want to include in your chart, and press Alt+F1. The chart is added to the worksheet and is listed in the Selection pane.

    • To create a Pie or Doughnut chart (to show a proportion of a whole when your total equals 100%), press Q. To select the type of Pie or Doughnut chart (to show a portion of a whole when your total equals 100 percent), press Q. To select the type of Pie or Doughnut chart, use the Down Arrow key and the Right Arrow key and then press Enter.

    • To create a Line or Area chart (to show trends over time or categories), press N. To select the type of Line or Area chart, use the Down Arrow key and the Right Arrow key and then press Enter.

    • To review a set of recommend charts for your data, press R. The Insert Chart window opens with a chart customized to showcase your data and the focus on the OK button. To select the recommended chart type, press Enter. To exit the Insert Chart window, press Esc. The recommended charts are customized to your data. For example, in the monthly budget example, if your Category column contains long text, a Clustered Bar chart might be recommended.

    The chart is added to your worksheet.

Select a chart so you can work with it

To work with a chart in Excel (for example, to add data labels or to make changes to the layout), you must first select it.

An easy way to select a chart is to use the Selection pane.

  1. To open the Selection pane, do one of the following:

    • Press Alt+P, A+P. The Selection pane opens with the focus on the Show All button.

    • Press Alt+Q. The focus moves to the Tell Me edit box. When you hear “Tell Me, Edit, Type and text,” type Selection pane and then press Enter. The focus moves to the Selection pane, and then press Enter. The focus moves to the Selection pane.

  2. To browse the items in the Selection pane, use the Down Arrow key.

  3. When you hear the name of the chart you want, press Enter. This selects the chart so you can work with it.

More information

Keyboard shortcuts in Excel 2016 for Windows

Use a screen reader to create a workbook 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!

×