Help with Excel waterfall chart

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finance Analyst
Commented:
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
Top Expert 2016
Commented:
Hi,

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

Open in new window

Regards

Author

Commented:
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