50 charts in PowerPoint

Creating charts in PowerPoint isn't straightforward and in many cases is a painful process. Users are usually obliged to copy/paste pictures from other software--which is not elegant--or to manually update numbers and push around shapes.

So here I'm offering you a PowerPoint template that includes 50 different chart types that are very useful in business. All charts are customizable using standard PowerPoint capabilities. This will improve the quality of your slides and make the process of slide creation more efficient.

Each template has a step-by-step section (on the Select Data sheet) to show you how to modify the inputs of the graph to suit your situation.

Labels
1. Stagger horizontal axis labels to avoid overlap with vertical bars for negative values.
2. Alternately stagger horizontal axis labels with a reference line to avoid overlap.
3. Bar chart with labels above bars.
4. Bar chart with labels inside bars.
5. Column chart with highlighting the maximum and minimum values.
6. Stacked bar chart--directly labeled without a legend--with the total labels.

Arrows and reference lines
7. Column chart with the CAGR arrow.
8. Column chart with an arrow to emphasize a specific data point.
9. Column chart with the total difference arrow.
10. Bar chart with a vertical reference line.
11. Column chart with a horizontal reference Line/Area.
12. Stacked area chart with doted lines to show projections--including a vertical line to separate actuals from forecast.
13. Range bar graph with doted lines to emphasize a specific data point.

Tile grid maps
14. Grid map with circles.
15. Grid map with squares.
16. Hex tile grid map.

Finance
17. Mirror stacked bar chart for profit and loss.
18. Combo chart that shows loan draws, loan repayments and outstanding loan balance.
19. Combo chart to show annual and cumulative cash flows including break-even point.
20. NPV chart that also shows the IRR.
21. Tornado Plot to show the sensitivity of a performance indicator (i.e. IRR) to changes in drivers.
22. Spider plot to show the sensitity of a performance indicator (i.e. IRR) to changes in drivers.
23. Income statement using a series of Bullet Graphs with alert dots.
24. Table of Sparklines.
25. OLB, PMT, AMORT and INT payments schedule for mortgages.

Project Management
26. Cost and schedule variance with management thresholds.
27. Life cycle phases and Quality of resources chart.
28. Development cost profile (S-Curve) chart.

Dot Plots
29. Dot plot (William Cleveland).
30. Lollipop chart.
31. Lollipop chart (variant 1).
32. Lollipop chart (variant 2).
33. Bar graph with end points.
34. Dumbbell chart.
35. Dumbbell chart (variant 1).
36. Range bar graph with end points.

Scatterplots and Matrices
37. Scatterplot with dynamic reference lines to split data into quadrants.
38. Dot-Dash plot to show a scatterplot with the marginal distributions along the axes.
39. Strip plot to show a a one-dimensional distribution with its box plot.
40. Barcode plot to show a one-dimensional distribution with its box plot.
41. Fourfold Chart to show contingency tables.
42. 3x3 matrix to show the performance snapshot of your employees.

Area charts
43. Fan Chart to show different scenarios.
44. Bivariate area chart to emphasize the difference between two curves.

Special charts
45. Flag chart.
46. Zvinca plot to rank a large data set that cannot fit in a bar chart.
47. Edward Tufte style bar chart with white gridlines and the frame of the vertical axis.

Calculus
48. 2D cartesian plot.
49. 2D parametric plot.
50. 2D polar plot.


System requirements

The template relies heavily on PowerPoint's Dynamic Arrays capabilities, only available to Microsoft 365 subscribers.

What's the refund policy?

If what you see is not what you expected, just reply to the download email within 30 days, and you'll get a full refund. No questions asked.