PlotArea question

[gromit12]

Hi there,

I have a chart I'm trying to build with VBA (Excel 2000). It's a
xlBarClustered type (horizontal bar chart) but it has unusually long
labels. What I want to do is to make the ratio of space for the labels
to bars roughly 75/25. PlotArea seems to include BOTH the data and the
labels, so resizing this doesn't seem to help - I just end up with
more whitespace if I try reducing the plotarea size.

Is there any way of controlling the size of the labels versus the
bars?

Any help much appreciated

Gromit

 

[Andy Pope]

Hi,

The simply answer is no. Excel automatically decides the area allocated
to labels.
If you want complete control over the axis labels the best solution
would be to add textboxes. Turn off axis labels and use vba to add,
position and format the appropriate number of textboxes.

Cheers
Andy