| 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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| 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) | |||
Linear Mode
