Time scale X axis with Major Unit of month

L

luvgreen

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!!
 
H

Holger Gerths

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

luvgreen

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.
 

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