Use a screen reader to create a PivotTable or PivotChart in Excel

Use a screen reader to create a PivotTable or PivotChart in Excel

Read out loud symbol with the label Screen reader content. This topic is about using a screen reader with Office

This article is for people with visual impairments who use a screen reader program with the Office products and is part of the Office Accessibility content set. For more general help, see Microsoft Support home.

Use Excel with your keyboard and a screen reader to create PivotTables or PivotCharts. We have tested it with Narrator, NVDA, and JAWS, but it might work with other screen readers as long as they follow common accessibility standards and techniques.

Use a PivotTable to calculate, summarize, and analyze data. You can quickly create comparisons, patterns, and trends for your data.

With a PivotChart, you can present your data visually, and quickly get the big picture of what's going on.

Notes: 

In this topic

Create a PivotTable

  1. In your worksheet, select the cells you want to convert into a PivotTable. Make sure your data doesn't have any empty rows or columns.

  2. Press Alt+N, V, then T. The Create PivotTable dialog box opens.

  3. The focus is on the Table/Range: box showing the selected cell range. Review the selection and use your keyboard to modify the range if needed.

      Create PivotTable dialog box in Excel for Windows showing the selected cell range and the default options.

  4. Once you're ready, press the Tab key until you reach the OK button, and press Enter. A new worksheet for the PivotTable opens. The PivotTable Fields pane opens to the right of the screen. 

  5. Press F6 until you hear: "PivotTable fields, type words to search for."

  6. You can now select the fields you want to use in your PivotTable. To browse the fields list, use the Down or Up arrow key. To select a field for your PivotTable, press Spacebar. The fields and their data are added to the PivotTable on the worksheet grid.

    The fields you select are added to their default areas: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.

  7. You can now move a field from one area to another if needed. In the PivotTable Fields pane, press the Tab key until you hear the name of the field you want to move. Then press Spacebar to open the context menu, press the Up or Down arrow key until you hear the option you want, for example, "Move to column labels," and press Enter. The PivotTable on the grid is updated accordingly.

    PivotTable Fields pane open in Excel for Windows showing selected table fields.  

Refresh a PivotTable

If you add new data to the data source of your PivotTable, all PivotTables that were built on that data source need to be refreshed. 

  1. In your worksheet, select a cell in the PivotTable you want to refresh.

  2. Press Shift+F10 to open the context menu.

  3. To refresh the data in the PivotTable, press R.

Create a PivotChart

  1. In your worksheet, select the cells you want to convert into a PivotChart. Make sure your data doesn't have any empty rows or columns. It must have only a single-row heading.

  2. Press Alt+N, S, Z and then C. The Create PivotChart dialog box opens.

  3. The focus is on the Table/Range: box showing the selected cell range. Review the selection and use your keyboard to modify the range if needed.

    Insert PivotChart dialog box in Excel for Windows showing the selected cell range and the default options.

  4. Once you're ready, press the Tab key until you reach the OK button, and press Enter. A new worksheet for the PivotChart opens. The PivotChart Fields pane opens to the right of the screen.

  5. Press F6 until you hear: "PivotChart fields, type words to search for."

  6. You can now select the fields you want to use in your PivotChart. To browse the fields list, use the Down or Up arrow key. To select a field for your PivotChart, press Spacebar. The fields and their data are added to the PivotChart on the worksheet grid.

  7. You can now move a field from one area to another if needed. In the PivotChart Chart pane, press the Tab key until you hear the name of the field you want to move. Then press Spacebar to open the context menu, use the Up or Down arrow key until you hear the area you want, for example, "Move to legend fields," and press Enter. The PivotChart on the grid is updated accordingly.

    PivotChart Fields pane in Excel for Windows showing selected table fields.  

Create a PivotChart from a PivotTable 

  1. Select a cell in the PivotTable you want to convert into a PivotChart.

  2. Press Alt+J, T and then C. The Insert Chart dialog box opens.

  3. To move the focus to the list of available chart types, press the Tab key once. You hear the currently selected chart type. To browse the list of chart types, use the Up or Down arrow key.

  4. Once you've found the chart type you want to insert, press the Tab key once to move the focus to the list of available chart subtypes. To browse the list of subtypes, use the Right or Left arrow key.

  5. Once you've selected the chart subtype you want, press Enter to insert the PivotChart to the worksheet.

See also

Use a screen reader to add, remove, or arrange fields in a PivotTable in Excel

Use a screen reader to filter data in a PivotTable in Excel

Use a screen reader to group or ungroup data in a PivotTable in Excel

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Use a screen reader to explore and navigate Excel

What's new in Microsoft 365

Use Excel with your keyboard and VoiceOver, the built-in macOS screen reader, to create PivotTables or PivotCharts.

Use a PivotTable to calculate, summarize, and analyze data. You can quickly create comparisons, patterns, and trends for your data.

With a PivotChart, you can present your data visually, and quickly get the big picture of what's going on.

Notes: 

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • This topic assumes that you are using the built-in macOS screen reader, VoiceOver. To learn more about using VoiceOver, go to VoiceOver Getting Started Guide.

In this topic

Create a PivotTable

  1. In your worksheet, select the cells you want to convert into a PivotTable. Make sure your data doesn't have any empty rows or columns.

  2. Press F6 until you hear the currently open tab. If the Insert tab is not open, press the Left or Right arrow key until you hear: "Insert."

  3. Press the Tab key until you hear "PivotTable," and press Spacebar. The Create PivotTable dialog box opens.

  4. The focus is on the Table/Range: box showing the selected cell range. Review the selection and use your keyboard to modify the range if needed.

  5. Once you're ready, press the Tab key until you reach the OK button, and press Return. A new worksheet for the PivotTable opens. The PivotTable Fields pane opens to the right of the screen. 

  6. Press F6 until you hear: "PivotTable fields."

  7. Press the Tab key until you hear: "Table." You can now select the fields you want to use in your PivotTable. To browse the fields list, use Shift+Control+Down or Up arrow key. To select a field for your PivotTable, press Spacebar. The fields and their data are added to the PivotTable on the worksheet grid.

    The fields you select are added to their default areas: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.

  8. You can now move a field from one area to another if needed. 

Create a PivotChart

  1. In your worksheet, select the cells you want to convert into a PivotChart. Make sure your data doesn't have any empty rows or columns. It must have only a single-row heading.

  2. Press F6 until you hear the currently open tab. If the Insert tab is not open, press the Left or Right arrow key until you hear: "Insert."

  3. Press the Tab key until you hear "PivotChart," and press Return. The Create PivotChart dialog box opens.

  4. The focus is on the Table/Range: box showing the selected cell range. Review the selection and use your keyboard to modify the range if needed.

  5. Once you're ready, press the Tab key until you reach the OK button, and press Return. A new worksheet for the PivotChart opens. The PivotChart Fields pane opens to the right of the screen.

  6. Press F6 until you hear: "PivotTable fields."

  7. Press the Tab key until you hear: "Table." You can now select the fields you want to use in your PivotChart. To browse the fields list, use Shift+Control+Down or Up arrow key. To select a field for your PivotTable, press Spacebar. The fields and their data are added to the PivotChart on the worksheet grid.

  8. You can now move a field from one area to another if needed. 

Create a PivotChart from a PivotTable

  1. First create a PivotTable.

  2. Select any cell in the PivotTable.

  3. Press F6 until you hear the currently open tab. If the Insert tab is not open, press the Left or Right arrow key until you hear: "Insert."

  4. Press the Tab key until you hear "PivotChart," and press Return. The PivotChart is created based on the data in the PivotTable.

See also

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Use a screen reader to explore and navigate Excel

What's new in Microsoft 365

Use Excel for the web with your keyboard and a screen reader to create PivotTables or PivotCharts. We have tested it with Narrator, NVDA, and JAWS, but it might work with other screen readers as long as they follow common accessibility standards and techniques.

Use a PivotTable to calculate, summarize, and analyze data. You can quickly create comparisons, patterns, and trends for your data.

With a PivotChart, you can present your data visually, and quickly get the big picture of what's going on.

Notes: 

  • If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office for the web. For more information, refer to Turn off virtual or browse mode in screen readers in Windows 10 Fall Creators Update.

  • New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. To learn how you can get new features faster, join the Office Insider program.

  • To learn more about screen readers, go to How screen readers work with Microsoft Office.

  • When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program. For example, you’ll use Ctrl+F6 instead of F6 for jumping in and out of the commands. Also, common shortcuts like F1 (Help) and Ctrl+O (Open) apply to the web browser – not Excel for the web.

In this topic

Create a PivotTable

  1. In Excel for the web, press F11 to switch to the full screen mode.

  2. In your worksheet, select the cells you want to convert into a PivotTable. Make sure your data doesn't have any empty rows or columns. It must have only a single-row heading.

  3. Press Alt+N, V. The Insert PivotTable pane opens to the right of the screen.

  4. To move the focus to the pane, press Ctrl+F6 until you hear "Select a table or range to analyze, edit," followed by the sheet name and the selected cell range.

    Insert PivotTable dialog box in Excel for the Web showing the selected cell range.  

  5. Press the Tab key until you hear "Create your own PivotTable," and press Enter. A new worksheet for the PivotTable opens. The PivotTable Fields pane opens to the right of the screen. 

  6. Press Ctrl+F6 until you hear "Table," followed by a table field name.

  7. You can now select the fields you want to use in your PivotTable. To browse the fields list, use the Down or Up arrow key. To select a field for your PivotTable, press Spacebar. The fields and their data are added to the PivotTable on the worksheet grid.

    The fields you select are added to their default areas: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.

  8. You can now move a field from one area to another if needed. In the PivotTable Fields pane, press the Tab key until you hear the name of the field you want to move. Then press the Down arrow key to open the context menu, press the Up or Down arrow key until you hear the option you want, for example, "Move to column labels," and press Enter. The PivotTable on the grid is updated accordingly.

    PivotTable Fields pane in Excel for the Web showing selected fields.

Refresh a PivotTable

If you add new data to the data source of your PivotTable, all PivotTables that were built on that data source need to be refreshed. 

  1. In Excel for the web, press F11 to switch to the full screen mode.

  2. Select a cell in the PivotTable you want to refresh.

  3. Press Shift+F10 to open the context menu.

  4. Press the Down arrow key until you reach the Refresh button, and press Enter.

Create a PivotChart from a PivotTable 

  1. In Excel for the web, press F11 to switch to the full screen mode.

  2. Select a cell in the PivotTable you want to convert into a PivotChart.

  3. Press Alt+N. The focus moves to the Insert ribbon tab.

  4. Press the Tab key once. The focus moves to the ribbon. Then press the Right arrow key until you hear the chart type you want, and press Enter.

    If you don't hear the chart type you want, you can look for additional chart types. Press the Tab key until you hear "Other charts," and press Enter. Use the arrow keys until you find the chart you want, and then press Enter.

  5. The list of available chart subtypes opens. To browse the list, use the Down arrow key. Once you're on the subtype you want, press Enter to insert the PivotChart to the worksheet.

See also

Use a screen reader to add, remove, or arrange fields in a PivotTable in Excel

Use a screen reader to filter data in a PivotTable in Excel

Use a screen reader to group or ungroup data in a PivotTable in Excel

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Use a screen reader to explore and navigate Excel

What's new in Microsoft 365

Technical support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.

A subscription to make the most of your time

Need more help?

Get support
Contact us
Expand your Office skills
Explore training

Was this information helpful?

×