Adding labels and changing label fields using VBA.

[Jason]

Thanks in advance for any response...

My first problem is that I need to add datalabels to pivotcharts via VBA.

I currently post about 160 different line and graph charts every month to
our intranet, and I do it automatically from Access using VBA. One of the
fields for the graphs is the "top performer" field. The execs that I do this
for don't want to know what the total of that field is, they just want to
know who (which location) made the designation on the chart (a different
field than the one being charted and compared).

So..my second problem is, how do you assign a different field as the label
then what's being charted?

Any help would be greatly appreciated.