Dear All.

I have produced a chart dynamically, using the technique outlined on the
Peliter website.

In general this works fine, in terms of when the list of data grows.
However, when my data list shrinks it causes a problem.

The data is the result of an Offset function, which leaves a blank cell
where there is no data. However, Excel charts a zero value - which I dont
want to have (I would rather it treat the cells as though they were blank).

Does anyone know how to do this???

Thanks.