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
From the course: Excel 2016: Charts in Depth
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Add a chart element3m 58s
-
Choose a chart layout with the QuickLayout option3m 55s
-
Select chart colors using Colorful and Monochrome palettes3m 38s
-
Style charts using the Design gallery or paintbrush icon2m 32s
-
Switch rows and columns for a different view of the data3m 17s
-
Change the location of a chart's source data4m 7s
-
Work with empty and hidden cells6m 22s
-
Change a chart's type2m 22s
-
Change the default chart type and save it as a template4m 54s
-
Change the location of a chart1m 39s
-
Move and resize a chart within a worksheet5m 6s
-
-
-
-
-
-
-
-
-