To create a Line or Area chart (to show trends over time or categories), press the Tab key repeatedly until you hear "Line, menu button," and press Control+Option+Spacebar. To select the type of the Pie or Doughnut chart, use the arrow keys to find the option you want, for example, "3-D Pie, button," and then press Control+Option+Spacebar.
To create a Pie or Doughnut chart (to show a proportion of a whole when your total equals 100%), press the Tab key repeatedly until you hear "Pie, menu button," and press Control+Option+Spacebar. To select the type of the Column or Bar chart, use the arrow keys to find the option you want, for example, "Clustered Bar, button," and then press Control+Option+Spacebar. To create a Column or Bar chart (to compare values across a few categories), press the Tab key repeatedly until you hear "Column, menu button," and press Control+Option+Spacebar. Press F6 until you hear the name of the current ribbon tab, for example, "Home, selected, tab." Press Control+Option+Right or Left arrow key until you hear "Insert, tab," and then press Control+Option+Spacebar to open the tab.ĭo one of the following to select a chart type: For more keyboard shortcuts related to selecting data, refer to section "Select cells, columns, or rows" in Keyboard shortcuts in Excel. VoiceOver announces the selected cells after each keystroke. You can select cells by holding down Shift and using the arrow keys to expand the range of selected cells. Select the data you want to include in your chart. To learn more about using VoiceOver, go to VoiceOver Getting Started Guide. This topic assumes that you are using the built-in macOS screen reader, VoiceOver. To learn how you can get new features faster, join the Office Insider program. New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. 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. For example, in the monthly budget example, if your Category column contains long text, a Clustered Bar chart might be recommended. The recommended charts are customized to your data. To exit the Insert Chart window, press Esc. To select the recommended chart type, press Enter. The Insert Chart window opens with a chart customized to showcase your data and the focus is on the OK button. To review a set of recommend charts for your data, press R. To select the type of the Line or Area 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 and then 1. To select the type of the Pie or Doughnut chart, use the Down arrow key and the Right arrow key and then press Enter. To create a Pie or Doughnut chart (to show a proportion of a whole when your total equals 100%), press Q. The chart is added to the worksheet and is listed in the Selection pane. Select the data you want to include in your chart, and press Alt+F1. Tip: You can quickly insert a basic Bar chart in a worksheet.
0 kommentar(er)
