How to avoid zero values in line chart

[Iniyan]

Hey all


am working with line charts and it compares Current year and last year trends. The data set actually comprises of 0-zero values for rest of current year.(Oct, Nov & Dec will be zero)When these values are considered for the line graph, the graph looks real bad as all forthcoming months hit zero values.


I tried various options of posting #N/A sorts as suggested in other forums but excel still treats these values as Null.

Need urgent help from experts on this.


Thanks,

Iniyan

 

[oldchippy]

Hi,


Have you looked here?


http://chandoo.org/wp/2009/12/14/how-to-hide-0-in-chart-axis/