By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,600 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,600 IT Pros & Developers. It's quick & easy.

Chart legends

P: n/a
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
Jul 5 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jul 5 '07 #2

P: n/a
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

Jul 5 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.