PlotArea question


G

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
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top