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

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/
_______


"mountainair" <mountainair@discussions.microsoft.com> wrote in message
news:C155E8A8-CDD1-4A80-BED6-8FC9CD08E1EB@microsoft.com...
> 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.

thanks jon, it worked!

"Jon Peltier" wrote:

> 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/
> _______
>
>
> "mountainair" <mountainair@discussions.microsoft.com> wrote in message
> news:C155E8A8-CDD1-4A80-BED6-8FC9CD08E1EB@microsoft.com...
> > 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.
>
>
>