PivotChart - Edit label names

[fire2ice]

I am using PivotCharts to graphically display my data. However, when I place the data into the chart it names the labels with the calculation (e.g. sum of X, count of X). How do I edit these? The only posting in the forum I saw recommended doing the sum in the query and then base the PivotChart on the query. However, the PivotChart still wants to perform a calculation and places the calculation name in front on the label.

I also went the route of using MSGraph as an object. This works well except how the data is place in the datasheet makes it so that the data is seen as the series instead of each set of data. Thus, I am having each plot point change color in the bar graph. Each bar correctly represents the information, but it is going to look like a crayon box threw up on it after a lot of data is entered.

So, that brings me back to the question of renaming the labels for each series.

I am using Access 2007 but the end users are mostly on 2003.

Thanks in advance.

 

[fire2ice]

I'm still looking for help on this. Anyone?

I did find a way around the issue and it does resolve my need. However, I would still like to know if this is possible.

My solution was to create nested IIF statements in a query that resulted in the category names I wanted. Then I simply put that field as my series and did a count on the primary field (ID). Works like a charm but creates the added hastle (and resources) of putting in this calculation for each PivotChart I wish to create. Hopefully someone can still come up with an answer to this issue.

Thanks again.