Once again please

#1 05-04-2005, 01:06 PM

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?

#2 05-04-2005, 02:06 PM

<<<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?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)