Join Dennis Taylor for an in-depth discussion in this video Create charts with shortcuts and standard techniques, part of Excel: Charts in Depth.
- [Instructor] In Excel, there's a variety of different ways to create a chart. One quick method is select the data that you're interested in showing in the chart. For example, on this worksheet called data selection in our chapter one file, if we wanted to show this data right here, in cells A2 over and down to cell G7, simply highlight the data, and if you'd like to have a chart on the same worksheet, press the keystroke combination, Alt + F1, that's the function key F1. Immediately, we see a chart right here on the same worksheet. If you prefer to have a chart on a different worksheet, a new worksheet, a sheet that has only a chart, your data's highlighted, press the function key, F11. You have the same chart. There are some advantages and disadvantages to working with a chart this way. Your focus is just on the one chart here. There's no data nearby. You can refine this as you wish and print it as you wish. Let's go back to that same sheet date, data selection. Remind ourselves of other methods of creating a chart. First of all, if the data that you're trying to show in a chart is surrounded by empty cells and/or worksheet boundaries as is the case here in the data from rows 12 through 18, you can simply click on a cell within the data and then press either Alt + F1 or F11 as we saw with the previous set of data, then there's the chart for the data here. At other times, maybe you're not so sure that you want to create a chart but you might be alerted to it. After highlighting data as I'm doing with the previous set of data here, as soon as I release the mouse button, a little icon appears to the right, the Quick Analysis button, click that, and we see an option for charts here and we could quickly pick one of the styles that we might be interested in. Clustered column option is same general chart we saw before. And there's another method too you might say the more methodical method, the data's selected and we go to the Insert tab in the ribbon menu system and off to the right, Recommended Charts, click the button, and the reason this is a good choice is that sometimes we see some options here that we might not have thought about, maybe an area chart is a good choice here, maybe not, but you're the judge but you are alerted to it, and also you'll see features like a funnel chart which probably would not be a good choice here but some others as well, so you are alerted to other types that you might not have thought of. People try this stacked column chart right here. We can either double-click this or click it to get a larger preview, then click OK. And of course, another is simply select the data, go to the Insert tab, and then pursue some of the chart options available with the buttons on the charts group here in the Insert tab. Maybe you're not quite sure but you got some familiarity with other chart types, you're exploring some of the choices here, click the little drop arrow, see some options here. Sometimes when you know exactly which chart type you want, this might be the best approach. I want this kind of a line chart, I'll simply click it, and we have a line chart. So multiple methods here of creating charts. Remember, two quick keystrokes shortcuts, either Alt + F1, F11, both of them create charts, one on the current worksheet, one on a different worksheet, and then there's more standard methods of using the Insert tab and the various choices available on the recommended charts and/or using some of the icons that we see just to the right.
- Chart essentials
- Fine-tuning charts with design tab choices
- Inserting pictures, shapes, and text boxes
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Changing a chart's data source
- Printing and sharing charts
- In-cell chart alternatives