Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Waterfall graph
Resolved · Medium Priority · Version 2003
Terry has attended:
Excel Advanced course
Excel Advanced course
How do I create a waterfall chart - it is not in the wizard.
Hi Terry, thanks for your query. The quick answer is you create a stacked column chart and turn off the fill colour of the base columns, thereby giving the illusion that the top level bars are floating in space. This link walks you through the process:
http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/
Hope this helps,
Anthony
|
|
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.09 secs.
