Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel waterfall charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Waterfall Charts

Excel Waterfall Charts

ResolvedVersion 2016

Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course

Excel Waterfall Charts

I would like to get an understanding of how to create waterfall charts in excel. Is there any useful content available that you are able to share to help me build my knowledge. Thanks

RE: Excel Waterfall Charts

Hi Kay,

Thank you for the forum question.

You have Excel 2016 and this makes creating a waterfall chart very simple. You need to have the source data structured right and that is all. Selected your source data and select the waterfall chart from the list of charts.

Please see attached example.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

WaterFallChart.xlsx

RE: Excel Waterfall Charts

thanks Jen

I am not seeing your attached examples - please can you
re send.

Many thanks

RE: Excel Waterfall Charts

Hi Kay,

If you refresh the browser, you should be able to find it under my signature. When we upload a file it takes a couple of minutes before it is available for the client.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Excel Waterfall Charts

Thanks Jen - it has come through now, thanks again.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.