Scatter plotting not working

R

richard

Hello everyone,

I am unable to get scatter plotting to work. when i chose
any other cart it will plot the points or graph but when i
chose scatter plot it will not. seems like it doesn't
read any of specified info. i can get it to work by first
selecting any other graph or chart and then choosing
scatter plotting. any ideas on a permanate fix for this?
thanks
 
J

Jon Peltier

Richard -

What's happening to your chart? Are all the points located up against
the left hand axis? Are they incorrectly spaced along the X axis?

Make sure that the X and Y values all are numeric (right adjusted in the
cells if there are no other formats applied). Make sure you select X and
Y ranges before running the chart wizard (the Y column should be located
to the right of X).

- Jon
 
R

richard

Jon,

All the values are numeric and are right adjusted now.
Still doesn't work. I can get excel to draw any other
chart except a scatterplot. Is there a setting where you
can force excel to imput the given data? Thanks Jon.
 
J

Jon Peltier

Richard -

Copy your data and paste it into your reply. Something might become evident.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top