line graph-need to pick up dates as values for the x axis?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you get a line graph to pick up and show dates as the values on the x
axis, not starting at zero nor at the first of the month. There doesn't seem
to be anywhere for x-axis data to be transferred to the x- axis. I did put
the dates into a row of cells and highlight them. i am using MS office 2000.
 
Go to Source Data on the Chart menu. On the Series tab, select the series,
then click in the XValues box, clear it if necessary, and select the range
that contains your dates.

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

Jon Peltier said:
Go to Source Data on the Chart menu. On the Series tab, select the series,
then click in the XValues box, clear it if necessary, and select the range
that contains your dates.

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