Column Chart shows "Sum of" in data Label

[code_hungry]

To Whom can help me,

I created a Column chart that gets data from a query. It initially had 4
columns and the data labels showed only the caption I had in each field in
the qry. Later was asked to add three more fields from teh query. These Three
fields I added today show the "Sum of" in the data label on the chart and I
cannot figure out how to remove that. I already checked the SQL and added
the "AS [xxxxxxx] I want to each field caption, but I am still geting wrong
results.

how can I omit the "Sum of?"

Thanks

 

[code_hungry]

Nevermind. I figured it out. I just had to go to the Pivot Table window and
change the caption there.