View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Scatter Diagrams

Use the XY chart type, not the line type, and make sure the chart is using
the X data.

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


"Greener2224" wrote in message
...
The x values will not display properly. They just plot as if they were the
numbers 1 2 3 etc but the y values are fine.
If I make the reverse the x and y data the graph works but is of course
not
in the format I want
Suggestions please