Discover how to create a Waterfall chart with positive numbers in PowerPoint.
🚀 UNLOCK the critical PowerPoint shortcuts trusted by industry leaders like KKR, American Express, HSBC, and more inside our free course here ► bit.ly/Learn-Critical-Shortcuts
⚑ SUBSCRIBE to get our latest PowerPoint tips and tricks bit.ly/PPT-Subscribe-Today
WHERE WE RECOMMEND FINDING POWERPONT TEMPLATES ONLINE
► bit.ly/Slide-Cow-PowerPoint-T...
► bit.ly/Envato-Elements-for-Po...
To learn more about our PowerPoint training seminars, premium PowerPoint Speed Training courses, and other useful PPT resources, visit our website below:
► bit.ly/PowerPoint-Speed-Training
In this PowerPoint tutorial, you'll learn how to create a waterfall chart in PowerPoint and Excel using positive numbers. It's important to note that the pre-office 2016 PowerPoint and Excel charting engines, do not include a waterfall chart category. So to pull this off, you actually need to trick PowerPoint and Excel and manually tweak a stacked column chart to pull off the waterfall chart.
This is how you start to create advanced PowerPoint charts.
And the trick to creating a waterfall chart, whether in Excel or PowerPoint, is a three step process:
#1: you need to calculate three separate data points for your waterfall chart
#2 you need to graph those three data points using a stacked column chart
#3: you need to hide the irrelevant data points and format your graph, which results in a professional looking waterfall chart
An additional point that I'll emphasize in this tutorial, is in building a robust Excel spreadsheet using dynamic ranges, that will save us a lot of manual adjustments in the future. Doing so takes a few extra minutes on the front end of the chart, but can save you hours on the backend of your chart, when you are updating everything.
This trick works in all versions of PowerPoint including PowerPoint 2007, PowerPoint 2010, PowerPoint 2013 and PowerPoint 2016.
I personally prefer this Waterfall chart method in PowerPoint 2016 rather than using the new Waterfall Chart Type.
Негізгі бет How To Create a Waterfall Chart in PowerPoint
Пікірлер: 5