[SOLVED] Time scale X axis with Major Unit of month

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

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


"luvgreen" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> 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!!

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

"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" <[email protected]> schrieb im Newsbeitrag
> news:[email protected]...
> > 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!!
>
>
>

[Kelly O'Day]

luvgreen:

You can do exactly what you want by using a dummy x axis series. I have a
number of dummy axis series examples on my site.

Take a look at this page to get some ideas.

http://processtrends.com/pg_charts_d...xis_series.htm

Kelly

[email protected]




"luvgreen" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> schrieb im Newsbeitrag
>> news:[email protected]...
>> > 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!!
>>
>>
>>