Thread: Dynamic Bar Chart Category Axis Problem

Hi

I have created a dynamic bar chart, roughly based on Stephen Bullen's
funchrt4. The number of categories can range from 2 to about 50 and ideally I
would like the category axis names font to be Arial 10 at least.
When the number of categories gets towards 50, the category axis names
disappear altogether and the only way I have found to retrieve them is to
manually reduce the font size to about 7 (dependent on the level of the
zoom). This font size is excessively small for the majority of charts.
Is there any way to get Excel2002 to keep the category axis names in all
circumstances without reducing them all to a very small font size?

--
Thanks

Richard

I have reposted this under a different subject heading
--
Thanks

Richard


"Richard" wrote:

> Hi
>
> I have created a dynamic bar chart, roughly based on Stephen Bullen's
> funchrt4. The number of categories can range from 2 to about 50 and ideally I
> would like the category axis names font to be Arial 10 at least.
> When the number of categories gets towards 50, the category axis names
> disappear altogether and the only way I have found to retrieve them is to
> manually reduce the font size to about 7 (dependent on the level of the
> zoom). This font size is excessively small for the majority of charts.
> Is there any way to get Excel2002 to keep the category axis names in all
> circumstances without reducing them all to a very small font size?
>
> --
> Thanks
>
> Richard