Excel Magic Trick #246: Waterfall Profit Chart (Create an Excel Waterfall Chart)

See how to create a Waterfall Profit Chart using a Stacked Column Chart, some formulas to create a second data set, and adding No Fill as a color to the second data series. Also see how to add Gap Width zero (0) so that the columns are touching.
Page 628 in the Learn Excel From Mr Excel book: Waterfall Profit Chart.

Category:

Science & Technology

Tags:

• Excel
• Waterfall
• Profit
• Stacked
• Column
• No
• Fill
• Formulas
• Chart
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Create
• an

[DavidHarris8]

Hi Mike,

You save me very many hours, thank you so much for your great videos!

At about 6:20 on the Waterfall Chart video, you say you could have drawn lines to join the bars. Is it possible to have Excel do that automatically? If that would require VBA, do you know of a tutorial that shows how please?

Many thanks.

David

[ExcelIsFun]

I am pretty sure it could be automated with formulas, but I do not have a video about that. Sorry about that.

[wahurak]

Best of Best!!!

[ExcelIsFun]

I am glad that you liked it!!

[vishy001]

This is really great. Many thanks. I have a question though...how do i overlay a line chart over this waterfall chart?

[ExcelIsFun]

Try this video:

Excel Magic Trick # 267: Percentage Change Formula & Chart

[excelguy01]

nice informative video thanks!

ive created an easy to use free waterfall chart creator that you can download off my forum

excelwithcharts com Please try it out and leave feedback :)

[AsthaW]

Hi Mike,

I tried to populate the value in blue column (COGS and Expense column) by selecting the rows as mentioned in the video and using Autosum ("Alt + = "),but it does not populate the values automatically as shown.I had to populate the values manually.Could you please provide assistance in this?

[erickim77]

Thank you. Your video instruction helped my report to look better.. Thank you.

[GodblessHunt]

You are the Best!!!!