charts

[snash]

Hi there, I've got a chart that's displaying amounts by GEO& by month, but all prior months are 0 for one GEO until Jan & feb. Is it possible to exclude the 0's in the previous months for this series?

 

[Andrew Poulsom]

Have you tried AutoFiltering your data for non-zero? Excel will only plot the visible cells if that option is checked under Tools|Options|Chart tab.

 

[number kruncher]

Where you have ZERO, replace this with #n/a, which will not be plotted.

 

[snash]

Thank you both. I actually manually removed the zeros' and left it blank and this now only plots the data values.

thanks again