having trouble with x-values in scatter plot

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

hi,

instead of plotting the values in the selected range,
excel takes those values to be the names of points, and
instead plots the order of the values. ie, instead of
graphing (1.2, 5), which is the fourth x-y pair in the
worksheet, it plots (4, 5). when i put my mouse over this
point in the scatter plot, excel tells me the point
is "point '1.2'". does anyone know what's going on?

thanks,
susan
 
Hi Susan,

Check the chart type is really xy-scatter and not Line chart.
hi,

instead of plotting the values in the selected range,
excel takes those values to be the names of points, and
instead plots the order of the values. ie, instead of
graphing (1.2, 5), which is the fourth x-y pair in the
worksheet, it plots (4, 5). when i put my mouse over this
point in the scatter plot, excel tells me the point
is "point '1.2'". does anyone know what's going on?

thanks,
susan
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top