Hello everyone,
I have created a chart in Excel ('03), with three series lines. At this
stage the data range for the chart is not complete, so there are some 0
values. Thus, the series lines drop down to 0 on the right hand side of the
chart.

Is it possible to have the series lines stop after the values which are 0?
Then, when the correct data is added into the chart, replacing the 0 values,
the series lines would continue.

Any help would be much appreciated. Thank you.