Please can someone tell me how to stop my charts plotting zero values
at the end in cases where the chart runs for a longer period than my
For example, my chart total date range is say Jan 05 to Dec 05, and I
have several lines to plot, the longest one extending for the whole 12
month period, but others for shorter periods from say Jan to Jun 05,
and Feb to Nov 05 etc. At the moment the way the source data is set
up, is that for the line item that ends in June, there are zero values
in the column for Jul to Dec 05 and my chart is plotting these zero
values, however I want my line to just end in June 05 otherwise my
chart looks odd.
The easy answer might be to delete the zero values from my source data,
but that will take a lot of fiddling around if I need to do that every
time I want to update my charts.
I am sure I remember turning off zero values once before, but I cant
Thanks in advance