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