Chart legends

[Bob Darlington]

Using Access XP I have a chart which displays the data I want according to
filters which yield either 5 or 25 categories.
The chart row source is set by the following:

".RowSource = TRANSFORM SUM(qsSumSalesCat.[SalesRate]) AS [SalesRate] SELECT
sDate FROM qsSumSalesCat WHERE sDate BETWEEN #05 31 2006# AND #05 31 2007#
AND (LeaseType ='Major' OR LeaseType = 'Mini Major')"

The chart displays OK.
My problem is that when I apply the filter to include only 5 selected
categories, the legend still shows all 25.
Where is the source for the legend set, and how do I change it to show only
the 5 categories being displayed?

--
Bob Darlington
Brisbane

[Tim Marshall]

Bob Darlington wrote:

The chart displays OK.
My problem is that when I apply the filter to include only 5 selected
categories, the legend still shows all 25.
Where is the source for the legend set, and how do I change it to show only
the 5 categories being displayed?

I don't use filters with charts. I would suggest rather than using a
filter, that you alter the where clause to get the results you want.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

[Bob Darlington]

Thanks for the reply Tim.
The filter is applied using the Where clause in the RowSource (see post).

--
Bob Darlington
Brisbane
"Tim Marshall" <TI****@PurplePandaChasers.Moertheriumwrote in message
news:f6**********@coranto.ucs.mun.ca...

Bob Darlington wrote:

>The chart displays OK.
My problem is that when I apply the filter to include only 5 selected
categories, the legend still shows all 25.
Where is the source for the legend set, and how do I change it to show
only the 5 categories being displayed?

I don't use filters with charts. I would suggest rather than using a
filter, that you alter the where clause to get the results you want.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me