PowerPoint WATERFALL Chart With MULTIPLE SERIES | Step-by-Step TUTORIAL Incl. EXCEL Links
HTML-код
- Опубликовано: 2 авг 2024
- ⚡ GET THE PowerPoint TEMPLATE HERE: payhip.com/b/w1AhO
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Learn how to create a waterfall chart with multiple series in PowerPoint Office 365 (or PowerPoint 2019), showing positive as well as negative numbers.
In this step-by-step PowerPoint tutorial I will show you how to easily create a dynamic waterfall, bridge or flying bricks chart by using the build-in chart functionality in PowerPoint.
You will learn how to use the underlying data sheet to prepare a dynamically linked, stacked waterfall chart. In particular, you will be shown how to prepare the Excel sheet as a template such that you can simply insert or delete multiple series and positive or negative numbers. The changes you make in the linked Excel sheet will be reflected immediately on the PowerPoint waterfall chart as stacked or single bars.
If you follow this PPT tutorial and make such a proper waterfall chart template with the ability to show multiple series and different kinds of values that are dynamically linked in the Excel sheet, you will save you a lot of time and effort in the future since you can easily reuse this generic chart template!
🚩 TABLE OF CONTENTS
00:00 Introduction
00:43 Insert the Right Chart Type to Create A Waterfall Chart With Multiple Series
02:20 Edit Data Directly in the PowerPoint Data Table (Alternative 1)
05:41 Edit Data in The Underlying Excel Sheet (Alternative 2) and Create a Template to Show Positive and Negative Values in a Stacked Waterfall Chart
10:56 Recap: How to Show Positive vs. Negative Values In a Waterfall Chart
12:48 Edit the Layout of a Stacked Waterfall Chart in PowerPoint
15:23 Complete the Waterfall Look
16:09 Adjust Chart Elements
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🔥 Want more professional PowerPoint presentation tips, slide designs & techniques?
Subscribe ► / @presentationmastery
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
MY FAVORITE OFFICE GEAR*
🖥️ My LG curved ultra-widescreen monitor: amzn.to/3ztOlkr
🐭 My Logitech wireless mouse MX Master: amzn.to/3Uao8jz
🎧 My Bose noise cancelling earphones: amzn.to/3UjbIWd
🔊 My Jabra speaker for video conferences: amzn.to/3fsyuMf
💻 My Lenovo Thinkpad X1 Carbon workhorse notebook: amzn.to/3WkevQE
🛋️ My BenQ ScreenBar: amzn.to/3WoUyIC
🆙 My height adjustable standing desk: amzn.to/3DxQBJ0
💡 My Philips Hue smart light bars: amzn.to/3TSX0W4
MY FAVORITE SOFTWARE/TOOLS*
📊 Microsoft 365: amzn.to/3zxnjcc
🔊 Where I listen to 30+ audio books per year: amzn.to/3gUOUgV
* Links are Affiliate links. This means I earn a small revenue share whenever a qualifying purchase is made via the link. The price for you stays the same = win/win 👍
🎧 Music by @ikson
#waterfallchart #stackedwaterfall #powerpointwaterfall
Thank you so much! I wanted to make one, and got this! Excellent explanation!! Thank you
amazing - been trying to do this all my life. thank you for the clear explanation!
Glad to hear that - thanks for the feedback!
Thank you. Very clear.
Yes! Thank you!
You are so welcome!
Great stuff! What if I want a total at the top of each bar too?
THANK YOU ! Your made my night ;) !!
Thank you. I think I need a bit more help if you don't mind?
If I have budget turnover and want to show variances (Volume, Mix, Price) to arrive at actual turnover how do I best display this as each of the three variances could be positive or negative each in reporting period. (I'm just looking to set up the graph so it auto populates once i have the data). It's not quite pulling through as i expect to see it. Do i need to look the budget turnover and actual turnover down because they are totals and ow do i do it when the column stack is split by multiple products?
*Do I need to lock down
Great
Thanks!
Could you share the excel sheet?
Thank you, thank you, thank you. You just saved the day!!!