From the course: Excel 2016: Charts in Depth

Unlock the full course today

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

Change the default chart type and save it as a template

Change the default chart type and save it as a template

From the course: Excel 2016: Charts in Depth

Start my 1-month free trial

Change the default chart type and save it as a template

- In Excel, the default chart type, unless you've changed it is what we call a stacked column chart. Perhaps like the chart to the right here of the data that we see in this worksheet called YearData. And anytime you create a chart quickly, either with a keystroke shortcut, alt F1 or F11, you will get a stacked column chart, unless you decide that that's not the chart you need most often. So, just as a quick example and a reminder here, this data is highlighted. I want a chart quickly, I'll press alt F1 or F11. I'll get a chart, alt F1 on this sheet, if I pressed alt F11, I'd get the same kind of a chart on a different sheet, a stacked column chart. But let's suppose I've been working with charts for a bit and I've found that in my organization, I prefer, and others do too, a stacked bar chart, or a clustered bar chart, so I'm going to switch this chart by way of Change Chart Type, to Bar chart, Clustered Bar. Now, that's the chart type that I'm going to be using most often. It…

Contents