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 Problem with xy scatter with dates

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?