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?

<<<smacks self in forehead

If I had only realized that having a cell display NA(), instead of typing in
"#N/A" worked, I could have saved myself much trouble. Thanks to those who
have posted the answer before.

"Wazooli" wrote:

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?