Thread
:
Time scale X axis with Major Unit of month
View Single Post
#
4
Posted to microsoft.public.excel.charting
Kelly O'Day
external usenet poster
Posts: 103
Time scale X axis with Major Unit of month
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
"luvgreen" wrote in message
...
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 With Quote
Kelly O'Day
View Public Profile
Find all posts by Kelly O'Day