Changing Legends labels?

[BobRoyAce]

I have a stacked bar chart on a report (based on a CrossTab query). Is it
possible to change the text labels shown in the legend. Access appears to
have chosen its own labels (appending SumOf to each).

 

[Duane Hookom]

These are pulled from the column headings in your chart's row source
property. You can modify the sql to create different headings.

 

[BobRoyAce]

I am not seeing where the SQL could be changed to give me
the legend labels I am looking for. It is the Table1.Team
values that are shown in the legend. However, for
whatever reason, instead of showing let's say "Team1", it
is showing "SumOfTeam1". I have included SQL below hoping
that you can tell me what I would change.

------- SQL BEGINS -------

TRANSFORM Sum(Table1.[Time(min)]) AS LostTime
SELECT FC.FunctionalCategoryDesc
FROM Table1 INNER JOIN (FC INNER JOIN Categories ON
FC.FCCd = Categories.FCCd) ON Table1.Category =
Categories.Category
WHERE Table1.FiscalYear =2004
GROUP BY FC.FunctionalCategoryDesc
PIVOT Table1.Team

 

[BobRoyAce]

Oops...never mind, I found where the label was getting
set incorrectly.