You could select just the Y values, start the wizard, and in step 2, click
on the Series tab, then select the X value dates.
Or you could put a label over the Y value dates, and leave the cell above
the X values blank, select the row with one label as part of the data range,
and start the wizard.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"janet" wrote in message
...
I am trying to create an x-y scatter chart where both the x values and the
y
values are dates. I highlight the 2 adjacent columns of date data and
click
on InsertScatter. Instead of a scatter graph, I get a line chart with 2
lines (the two data columns). The x values on the graph are simply a
count
of the data points as in a line chart.
If the 2 columns of data are not dates, I get the correct scatter chart,
but
not if the x-values are dates in which case I get a line chart. How can I
get a scatter chart with both x-values and y-values as dates?