Want a shortcut to making super sexy charts on your Mac desktop and have access to the final Excel files? Apply these chart templates to your data by following the instructions in the book or by following the instructions on the office.com site.
You can see below a list of the charts that come with templates.
- 100% Stacked Area
- 100% Stacked Bar – Labels
- 100% Stacked Bar
- Area
- Band – Multiple
- Band – Single
- Bar – Highlight
- Bar
- Baseline Delta
- Clustered Column
- Column – Highlight
- Column – Mean
- Column
- Combination – Area
- Combination – Line
- Cycle Plot
- Diverging Bar
- Diverging Stacked Bar
- Donut Exploding
- Donut
- Floating Bar
- Line Sizzle
- Line
- Lollipop – Data Labels
- Lollipop
- Pictograph
- Pie – Accent
- Pie – Exploding
- Pie
- Radar
- Stacked Area
- Stacked Column – Total
- Stacked Column
- Stock – HLC
- Stock – OHLC
- Stock – VHLC
- Stock – VOHLC
Note:Â Some of the features in the more advanced (aka hacked) charts are lost when you save it as a template. You will need to follow the instructions in the book to find out how to retrieve these features.
And below is a list of the Excel workbook files that come in this download.
- 100% Stacked Bar
- 100% Stacked Area
- Area Chart
- Band Chart
- Bar Chart
- Baseline Delta Chart
- Box Whisker Chart
- Bubble Chart
- Clustered Column Chart
- Clustered Stacked Column Chart
- Column Chart
- Combination Chart
- Cycle Plot
- Diverging Bar Chart
- Diverging Stacked Bar Chart
- DOJ Makeover
- Dot Plot
- Dumbbell Plot
- Floating Bar Chart
- Formatting Disaster Final
- Gauge Chart
- Heatmap
- Histogram
- Line Chart
- Lollipop Graph
- Map Chart
- Pareto Chart
- Pictograph
- Pie Chart
- Pivot Table
- Radar Chart
- Scatter Plot
- Slope Chart
- Small Multiples
- Sparklines
- Stacked Area Chart
- Stacked Column
- Stock Chart
- Sunburst Chart
- Table Formatted
- Treemap
- Waterfall Chart
Photo Credit: Fleur