Using Excel 2003

Have a range of data containing some "empty" cells. However, as they
come from a formula they aren't of course empty.

Am using this data to plot an X-Y chart where I want these "empty"
cells not to plot. Have set the tools-options-charts setting to Not
plotted.

Have read numerous other postings here and elsewhere which says to have
#N/A as my "empty" value. It still interpolates the points.

Seen a posting suggesting I use VBA but unless this is relatively
simple, is a bit beyond me (and can't find a posting with any code)

Any suggestions?

Thanks

Paul


--
paulch
------------------------------------------------------------------------
paulch's Profile: http://www.thecodecage.com/forumz/member.php?userid=588
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120953