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.