The Secret to Dynamically Change the Colour of Waterfall chart to Red & Green Color in Excel

Опубликовано: 05 Апрель 2023
на канале: Lighthouse Analytix

10,206

Learn how to create waterfall chart and change the colour of the waterfall chart to any desired colour, e.g. Red and Green or Pink and Green

If you are sick of changing the colour manually and want to know the quick and easy way of setting up a waterfall template that can dynamically update the colour of the waterfall chart, depending on the data value... this video is for you.

Let me tell you a secret... changing the colour of the waterfall to the correct shades of red and green is something that I have always wanted to do... but never had the time to pause and learn. Thus I have always done it the quick way, but not necessarily the smart way. When I finally learnt how to do it the proper way, I knew that I needed to create a video about it so that I can share my learnings with all of you...

In this video, I will show you:
1. How to create a sales waterfall chart in Excel from Scratch
2. How to modify the color the quick but not necessarily smart way...
3. How to modify the color dynamically... the proper way
4. How to modify the color theme... just in case you want to select different colours
5. How to make small tweaks to improve the look & feel of your waterfall charts.

Hope you find this video useful in your day to day life !!!

Cheers,
Isabella Susilowati
‪@LighthouseAnalytix‬ #exceltutorial , #exceltips, #waterfall.

Timelines:
00:00 Introduction
00:16 How to create a waterfall chart?
01:29 How to change waterfall colour?
02:17 How to change waterfall colour dynamically?
03:11 How to modify the colour theme?
03:38 How to enhance your waterfall chart?
04:06 Epilogue

LA104