Form Pivot Chart legend labels show SUM

degimp

New member
Local time
Today, 02:32
Joined
Aug 20, 2010
Messages
7
How do I change the legend labels of a pivot chart form so that it doesn't show the words "sum of" in front of my description. I am using access 2007.
 
I had a similar issue recently.

Do you have the data as below:

Code:
Example 1

Label      Value

Label1    100
Label2    200
Label3    300
etc

Or Example 2

Label1   Label2    Label3    etc

100       200        300
I had the data as per example 2 and had all of my labels as sumOf

I changed the data so it showed as in Example 1 and it worked

There maybe some other way to fix your problem that I am not aware of
 
I still have not found a fix for this, does anyone else have any ideas?
 

Users who are viewing this thread

Back
Top Bottom