excel chart and data don't match, help

U

uwcoug

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 "1.230"
(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!
 
K

Kelly O'Day

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.
 
U

uwcoug

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
 
Top