Bar Chart Label Positioning

Hi VBA Pros,

I have dozens of 36 similiar bar charts. I created one chart and
copy-paste it to get the other 35 charts. Then I linked each to
different data source to get my report. But my problem is that the
bar-value-labels in each chart would move accordingly. I have to
manually move each label in each chart. I download Mr. Rob Bovey's XY
Chart Labeler. It just make my adjustment more accurate, I still have
to move the label one by one. But it is something I am looking for if
it could do all the labels at once. Could some one help me with some
codes so that the label will move to a right position as long as the
data source changed?

Many thanks,
Michael

Michael -

Is the right position one of the built in types? For example, a column
chart has center (default), inside base, inside end, and outside end.
The Chart Labeler allows you to set the position when you add the
labels, while formatting the labels also allows you to change the
position. If the "right" position is something else, though, you're out
of luck, unless it's predictable enough that you could write a macro to
do it for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

michael way wrote:

Hi VBA Pros,

I have dozens of 36 similiar bar charts. I created one chart and
copy-paste it to get the other 35 charts. Then I linked each to
different data source to get my report. But my problem is that the
bar-value-labels in each chart would move accordingly. I have to
manually move each label in each chart. I download Mr. Rob Bovey's XY
Chart Labeler. It just make my adjustment more accurate, I still have
to move the label one by one. But it is something I am looking for if
it could do all the labels at once. Could some one help me with some
codes so that the label will move to a right position as long as the
data source changed?

Many thanks,
Michael