Convert X-Axis Scale from Day/Month/Year Options to Actual Numbers
 

1) I have some charts where the X-Axis scale is calibrated by entering dates,
and minor/major tick marks are in whole days/months/years.

2) I have similar charts where the X-Axis is calibrated using numbers that
represent dates (i.e. 39287 for 7/24/07) and I can use numbers with multiple
decimal places to set the major minor tick marks.

How can I convert (1) to (2)?

Chart (1) is difficult to use because the dates never line up as I want
(with a specified beginning and ending date). Chart (2) does allow me to set
a specified date at each end of the X-Axis.

Convert X-Axis Scale from Day/Month/Year Options to Actual Numbers
 

The first axis sounds like a line chart's time scale category axis, the
second sounds like either of an XY chart's axes. You'd convert the first
axis to the second by changing the chart type. Here's some information on
the topic:

X Axis: Category or Value?
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CJMITCHELL" wrote in message
...
1) I have some charts where the X-Axis scale is calibrated by entering
dates,
and minor/major tick marks are in whole days/months/years.

2) I have similar charts where the X-Axis is calibrated using numbers that
represent dates (i.e. 39287 for 7/24/07) and I can use numbers with
multiple
decimal places to set the major minor tick marks.

How can I convert (1) to (2)?

Chart (1) is difficult to use because the dates never line up as I want
(with a specified beginning and ending date). Chart (2) does allow me to
set
a specified date at each end of the X-Axis.

Convert X-Axis Scale from Day/Month/Year Options to Actual Num
 

Perfect. Changing from a line to scatter chart did the trick.
Thank you very much.

"Jon Peltier" wrote:

The first axis sounds like a line chart's time scale category axis, the
second sounds like either of an XY chart's axes. You'd convert the first
axis to the second by changing the chart type. Here's some information on
the topic:

X Axis: Category or Value?
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CJMITCHELL" wrote in message
...
1) I have some charts where the X-Axis scale is calibrated by entering
dates,
and minor/major tick marks are in whole days/months/years.

2) I have similar charts where the X-Axis is calibrated using numbers that
represent dates (i.e. 39287 for 7/24/07) and I can use numbers with
multiple
decimal places to set the major minor tick marks.

How can I convert (1) to (2)?

Chart (1) is difficult to use because the dates never line up as I want
(with a specified beginning and ending date). Chart (2) does allow me to
set
a specified date at each end of the X-Axis.