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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CJMITCHELL - 25 Jul 2007 21:12 GMT

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.

Reply to this Message

Jon Peltier - 26 Jul 2007 04:13 GMT

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/ChartsHowTo/CatVsValueAxis.html

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

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

> 1) I have some charts where the X-Axis scale is calibrated by entering
> dates,
[quoted text clipped - 11 lines]
> set
> a specified date at each end of the X-Axis.

Reply to this Message

CJMITCHELL - 31 Jul 2007 01:02 GMT

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

> 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
[quoted text clipped - 29 lines]
> > set
> > a specified date at each end of the X-Axis.

Reply to this Message