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

C

CJMITCHELL

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.
 
C

CJMITCHELL

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top