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
LVL 1
agwalshAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
In answer to number 1:

Right click on Axis and Select Format Axis. In the pane that appears to the right of the screen Select the Labels Section, it should expand when you click on it. One of the options is Label Position with Options Next to Axis, High, Low and None. Next to Axis is what you have. High will put the labels at the top of the chart, Low will put them at the bottom. None will obviously get rid of them.

Thanks
Rob H

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rgonzo1971Commented:
Hi,

If you want to Show Numbers not Zero  Change the Format to Custom
0;-0;""

Open in new window

Regards
agwalshAuthor Commented:
Excellent - knew it was something simple I was missing :-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.