How to Use xllabelpositionbestfit

[davidpcurtis]

I trying to automate the label attachments on a stacked bar chart. I
want to have the system apply them automatically. This I can do. But I
am trying to keep them from showing straight up the middle, as then
they are all bunched up togehter and un-readable. I am trying to use
xllabelpositionbestfit or xllabelpositionmixed, but can not get the
syntax quite right. At this I am not even sure if I can do what I want
to do. Please advise !!!

 

[Jon Peltier]

David -

Bad news. xlLabelPositionBestFit is not available on stacked bar
charts, but only in pie charts, as I recall. I assumed that
xlLabelPositionMixed is what you get when the labels within a series
have different positions, but a two minute test didn't bear this out.

It's possible to apply different positions to each label in a series,
and in fact, you can change a label's position by changing its .Left and
..Top properties.

- Jon