software

I have a large spreadsheet and when I try to plot columns in a scatter plot I
don't get what is in the columns. For example this is what you get when you
click on a ponit in the chart,

Series 1 Point quot;1.230quot;
(2371, 18.41)

The actual data point is 1.230,18.41, the 2371 is nowhere to be found in
either column or the whole spreadsheet for that matter.
Help!

How do you have your data organized? If you repost with an example of 5 -
10 rows, I'll try to reproduce your problem and see if I have a solution.

quot;uwcougquot; gt; wrote in message
...
gt;I have a large spreadsheet and when I try to plot columns in a scatter plot
gt;I
gt; don't get what is in the columns. For example this is what you get when
gt; you
gt; click on a ponit in the chart,
gt;
gt; Series 1 Point quot;1.230quot;
gt; (2371, 18.41)
gt;
gt; The actual data point is 1.230,18.41, the 2371 is nowhere to be found in
gt; either column or the whole spreadsheet for that matter.
gt; Help!
I just now figured out my problem. In my 4500 row by O column wide
spreadsheet, I had 3 cells that were blank. By putting in -99 for missing
values, the plot gets the right data pairs. Kelly, thank you for responding.
Cheers,
uwcoug