From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create charts instantly with either of these keystroke shortcuts

Create charts instantly with either of these keystroke shortcuts

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Create charts instantly with either of these keystroke shortcuts

“

- [Voiceover] Although Excel has many tools for creating charts, you can create a chart quickly and totally avoid the menu system. I liked to create a chart showing this data right here, somewhat like this chart to the right, but maybe a different type. I've got my data highlighted. To create a chart on the current worksheet, select the data you want to appear in a chart and simply press Alt + F one and there is a chart, right on the worksheet. If you'd like to have the chart on its own separate sheet, have your data highlighted and simply press the F 11 key. You'll see the same kind of chart, but over on a separate sheet. Notice the new sheet name at the bottom, it'll be on sheet called chart one or if you have others, chart two, chart three, so on. In both cases, you have all of the chart tools available to you by way of the design and format tabs. The charts for the moment look identical and we can create the same kind of chart in either location. Jumping back to chart data here…

Contents