Showing a gap / hiding zero values on excel area chart

[jonhowlett]

Hi


I would like to know how I can hide the green shaded budget area point from December to January in the file which can be downloaded by using the link below.


https://www.dropbox.com/s/q1maz6787t9flpb/Area%20chart.xlsx


I am wanting the area 'budget' series to only begin in January and not rise from zero in December to January's value. I have tried Chart tools - select data - hidden and empty cells set to 'show empty cells as gaps' as well as using the =NA() formula for all month before January, however just cant seem to work it out.


The hiding columns trick won't work in this instance either due to the formatting of my actual, forecast and budget lines which are rows which dynamically update each month. Preferably I'm after a non VBA solution and hope its just something in my chart that I don't have right.


Thanks for the help!

 

[kaushik03]

Hi jonhowlett,


Welcome to the forum.


I am not able to download your file due to firewall policy, but looks like you are looking for something like this:


http://datapigtechnologies.com/blog/index.php/suppressing-zeros-in-chart-labels/


Kaushik

 

[jonhowlett]

Hi


Thanks for the quick reply.. saw that article which is a stack bar chart - it unfortunately doesn't really help me.


I'm trying to work out how to get an area chart to draw/fill just from the value 67 in January onwards (leaving a gap from the zero or NA# value in December). Currently my chart is filling the area from from zero in December up to 67 in January which I don't want it to do.