From the course: Excel 2019 Essential Training

Unlock the full course today

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

Exploring chart types

Exploring chart types

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Exploring chart types

- [Narrator] It's not always clear which chart type is gonna work best for you: column, bar, line, or others. But because it's so easy to change a charts type you should explore some of the many types available. Looking at the worksheet called chart types, in the workbook 07 charting, the default chart type in Excel is called clustered column. I'm highlighting the data from cells A2 over to E7, and the quick way to create a chart, Alt + F + 1, I'll use it here. That's a custard column chart and that might be ideal for your data. But don't just stop there and assume that it's the best chart. When the chart is created it is selected in the design tab, the contextual design tab and format tabs are available. On the design tab is the all-important change chart type, click it. Sometimes you have to move the title bar around so you can keep an eye on the chart. Column, we see some variations. Here's a stacked column, sometimes that's better. It's less crowded, it shows the data in a…

Contents