G
Guest
I know this has been addressed before, but I can't seem to find a
satsifactory answer. I have a 3 data sets to be plotted together on an X-Y
scatter chart. Unfortunately, the data contains large gaps. Since the data
is dynamically updated via combo boxes, I don't want to have to filter out
cells that are empty. At first I filled empty cells with "", but after
reading several posts, I tried entering "0" instead. This is still not a
fix. I am getting the feeling I am going to have to use VBA to dynamically
fill arrays to be plotted, but that is hopefully a last resort. Any
suggestions?
wazooli
P.S. The data that does plot does so in a strange manner: if the X-Y values
of the first data point are, for instance, 1834 & 2741.1, the point that is
plotted is 1,2741.1. Any ideas why this is happening?
satsifactory answer. I have a 3 data sets to be plotted together on an X-Y
scatter chart. Unfortunately, the data contains large gaps. Since the data
is dynamically updated via combo boxes, I don't want to have to filter out
cells that are empty. At first I filled empty cells with "", but after
reading several posts, I tried entering "0" instead. This is still not a
fix. I am getting the feeling I am going to have to use VBA to dynamically
fill arrays to be plotted, but that is hopefully a last resort. Any
suggestions?
wazooli
P.S. The data that does plot does so in a strange manner: if the X-Y values
of the first data point are, for instance, 1834 & 2741.1, the point that is
plotted is 1,2741.1. Any ideas why this is happening?