- [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 + F1, we've got a chart right here.…
Released
1/17/2019- Identifying chart elements and chart types
- Creating a basic chart
- Choosing a chart layout and style
- Working with column, bar, and line charts
Share this video
Embed this video
Video: Create charts with keystroke shortcuts and the Quick Analysis tool