Greetings:

I am charting data which is not contiguous. If I leave a cell empty,
the chart treats it like a zero (which it isn't). If I drop a #N/A
into the cell, the chart ignores it, which is fine. On the downside,
if there's a #N/A within the base data, AVERAGE() will return #N/A too.

I'd like to have my cake and eat it too. Suggestions?

Thanks;
Duncan