View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Holger Gerths Holger Gerths is offline
external usenet poster
 
Posts: 29
Default 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!!