| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| convert number to month and year in formula | Excel Worksheet Functions | |||
| Time scale X axis with Major Unit of month | Charts and Charting in Excel | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
Threaded Mode
