Too Many X Data Labels

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a
courtesy email copy was sent to Christopher C. <cj.ch...@gte.net>.
Please use the newsgroup for further discussion.]

Format the x-axis (double-click it or click on it and then select Format
| Selected axis...) and in the Scale tab set the major unit to 5 days

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--
In <elVUUg1w$GA.217@cppssbbsa03>, Christopher C. <cj.ch...@gte.net>
wrote
> I am trying to plot the standard High, Low, Close for every trading day for
> 90 days for a specific stock.
> Unfortunately, the x axis becomes unreadable since there of 90 labels. How
> can I have Excel2000 only show the label for every 5 days in the X-axis but
> plot every day?
> Thanks so much in advance.
>
>
>

[CJ Chapman]

Thanks for your quick responce.
Unfortunately, I cannot find "Major Unit" in the Scale Tab, Category (X)
axis scale. The only options are
"Value (Y) crosses at category number:",
checkbox of "Categories in reverse order,
checkbox of "Value (Y) axis crosses at maximum category"
The following are grey'd out:
"Number of categories between tick-mark labels:"
"Number of categories between tick marks:"
checkbox "Value(Y)axis crosses between categories"
Any Ideas?
Thanks, Christopher

Tushar Mehta <ng_p...@bigfoot.com> wrote in message
news:MPG.1392f9ea6...@msnews.microsoft.com...

[Peltier]

This is a line chart you've made. You can change the entry for Number
of Categories between tick-mark labels (enter 5 or whatever), or you can
change your chart into a scatter chart, and change the major unit scale
as Tushar suggested.

- Jon
_______

[CJ Chapman]

Currently my labels were made from the StockName and Date, which gave me all
my problems. When I changed it to just the Date, I have all the options
that I want for the xaxis. It must get confused when the labels are in two
columns.
Thanks to all for your help.
Peltier <pel...@home.com> wrote in message
news:3929DC8B...@home.com...

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a

courtesy email copy was sent to CJ Chapman <c...@seattlelab.com>. Please

use the newsgroup for further discussion.]

I'm glad we got that resolved since I've been struggling with possible
causes. Didn't think of a combination as the cause!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--
In <eCJ8rdPx$GA....@cppssbbsa02.microsoft.com>, CJ Chapman
<c...@seattlelab.com> wrote