Help with Excel waterfall chart

agwalsh used Ask the Experts™
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 :-)
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finance Analyst
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.

Rob H
Top Expert 2016

If you want to Show Numbers not Zero  Change the Format to Custom

Open in new window



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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial