Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time scale X axis with Major Unit of month
Hello all. I am trying to graph a scatter XY chart with x Axis as date. I
want it to show as 1/1/2006, 2/1/ 2006, 3/1/2006, but I can't manage to make it happen. Is there a way? BTW, I can't use category, because I need the time scale. Thank you much!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time scale X axis with Major Unit of month
Hi,
the problem is, that you are not able to change the axis-type into "time-axis". You can add a non-visible column-chart-row (height 0) and after you CAN change the axis-type into "time-axis". Then you can format the axis as a time-axis. Did this solve your problem? Greetings, Holger. "luvgreen" schrieb im Newsbeitrag ... Hello all. I am trying to graph a scatter XY chart with x Axis as date. I want it to show as 1/1/2006, 2/1/ 2006, 3/1/2006, but I can't manage to make it happen. Is there a way? BTW, I can't use category, because I need the time scale. Thank you much!! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time scale X axis with Major Unit of month
Thank you for your reply Holger. I can't do that. I need the X axis to be
real time scale with the first day of each month, because I have another time series data values 0 needs to be plotted on the X axis base on date. Thanks. "Holger Gerths" wrote: Hi, the problem is, that you are not able to change the axis-type into "time-axis". You can add a non-visible column-chart-row (height 0) and after you CAN change the axis-type into "time-axis". Then you can format the axis as a time-axis. Did this solve your problem? Greetings, Holger. "luvgreen" schrieb im Newsbeitrag ... Hello all. I am trying to graph a scatter XY chart with x Axis as date. I want it to show as 1/1/2006, 2/1/ 2006, 3/1/2006, but I can't manage to make it happen. Is there a way? BTW, I can't use category, because I need the time scale. Thank you much!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y Axis Scale Problem | Charts and Charting in Excel | |||
Changing Time Scale to Seconds on Excel Chart | Charts and Charting in Excel | |||
Time on the X Axis Issue | Charts and Charting in Excel | |||
Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
secondary axis scale | Charts and Charting in Excel |