Plotting XY values in a chart

[Guest]

Hey there,

I am trying to plot specific values on the X and Y axis and when I use the
chart wizard it creates two lines with the Y values being generic preselected
values. Can someone help?

 

[Debra Dalgleish]

If you have a heading on the first column, remove it, then try creating
the chart. Usually that makes it easier for the Chart Wizard to work
correctly.

Jon Peltier has a Charting tutorial that may help you:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html

 

[Jon Peltier]

Robin -

In addition to Debra's suggestion, make sure you're making an XY Scatter
chart, not a Line chart. A line chart treats the X axis as a set of
nonnumeric labels, regardless of whether the cells contain numbers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______