Series lines - can someone help?

[A little stuck]

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.

 

[Jon Peltier]

You can set up dynamic ranges for the data, which are based on the
number of values > 0. Here is some help:

http://peltiertech.com/WordPress/dynamic-charts/

There are lots of links to similar examples at the end of that page.

It might be better to have your formulas return something other than
zero if the cells they link to are blank. Something like this:

=IF(A1="",NA(),A1)

will put #N/A into a cell if A1 is blank. Looks strange, but it is not
plotted in a line or XY chart. In some cases, this approach is all you
need, without the dynamic range names of the approach in the page I
cited above.

- Jon