Changing Legends labels?

B

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).
 
D

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.
 
B

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
 
Top