From the course: Excel: Introduction to Charts and Graphs

Unlock the full course today

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

Create charts with keystroke shortcuts and the Quick Analysis tool

Create charts with keystroke shortcuts and the Quick Analysis tool

From the course: Excel: Introduction to Charts and Graphs

Start my 1-month free trial

Create charts with keystroke shortcuts and the Quick Analysis tool

- [Instructor] Once you have selected data to appear in a chart, there are three quick methods for creating a chart. We're on the worksheet called Data Selection in the Chapter Two creating file. Let's suppose that we want to create a chart based on the data that I'm highlighting right here from cells A2 over and down to G6. If we want to chart on a separate sheet, a new sheet, we simply press the function key F11. There's a new sheet. Notice at the bottom of the screen, it's called Chart1. If we already have a Chart1, it'll be Chart2, Chart3, et cetera. We have a Design tab and a Format tab in the ribbon, we've got all the tools available to fine-tune this chart as we wish. It's not next to the data, and that could be okay, the focus is strictly on the chart. Let's go back to that data selection sheet. When the data's highlighted, and it still is here, if we want to create a chart on the current sheet, the keystroke shortcut Alt + F1, and that means using the function key F1, Alt +…

Contents