Link to home
Create AccountLog in
Avatar of agwalsh
agwalsh

asked on

Help with Excel waterfall chart

hi Folks
Been experimenting with Waterfall charts (this is Excel 2010) and I'm attaching what I have so far. My question is this
1. How can I move the axis down so that the negative numbers are not overwriting the month names?
2. How can I get the labels to show so that they only show the numbers not 0. I suspect it's an N/A thing but if so, then how do I get the formula to work with that? Thanks as always :-)
EE-Waterfall-chart.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of agwalsh
agwalsh

ASKER

Excellent - knew it was something simple I was missing :-)