 |
 |
 |
 |
 |
|
|
||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
11-23-2005, 12:15 PM
|
|||
|
|||
|
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. 
|
|
#2
11-23-2005, 02:30 PM
|
|||
|
|||
|
Re: line graph-need to pick up dates as values for the x axis?
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.
|
|
#3
11-23-2005, 05:10 PM
|
|||
|
|||
|
Re: line graph-need to pick up dates as values for the x axis?
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. > > >
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
