Changing Legends labels?

  • Thread starter Thread starter BobRoyAce
  • Start date Start date
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).
 
These are pulled from the column headings in your chart's row source
property. You can modify the sql to create different headings.
 
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
 
Back
Top