How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars

In Office 365, it is very easy to create a waterfall chart with the new chart available pre-built.
But formatting these charts - especially changing colors of the increase and decrease bars - is very challenging.
These charts don't behave the same way as some of the pre-built charts in MS Office.
In this video you will learn how to create a waterfall chart, format them and make it into a pictograph with arrows instead of boring colors.

[@pierrejoubert29]

Very usefull.. thanks!👏

[@camiloescallon4387]

Thank you very much, you just made my life so much easier. It's incredible that microsoft hasn't made the formating of these graphs more straightforward!

[@TheHairykoala]

Thank you! Very useful video.

[@anshulb1986]

I am not able to select individual legend to change color. Any clue why?

[@DanteCry23]

I second this. I cannot select the individual legend.

[@wildchildOz]

@@DanteCry23 also here

[@avipawar89]

Thank you for the valuable video. request you to please don't use background music.

[@ProfectusLearning]

Hey, thanks for the feedback. I'll factor that in the future videos.