Condensed pie chart

[HORH]

I used to make a pie chart in an Access 2003 Report, categorized and sum'ed from record fields in a table

The number of categories has now known so that the number of pie 'slices' and 'legend texts' becomes unreadable.

Is there any way to condense the smallest pie slices - e.g. where field sum < 1000 - into a sigle 'Other - slice'? Without any/too much programming, please.

Rgds.
HORH

 

[traingamer]

use two queries - with the first define the data you want to display as 'other'

subquery1:

select [field in legend now], iif(sum([field you are counting]) < 1000, "Other", [field in legend now]) as NewType
from yourtable
where...
group by [field in legend now];

Then select your data and graph the 'NewType' field

select subquery1.NewType, sum([field you are counting])
from yourtable INNER JOIN subquery1 ON yourtable.[field in legend now] = subquery1.[field in legend now]
where ...
group by subquery1.NewType
order by ...

Adjust as needed.
Hope that makes sense - I've use many similar queries to consolidate 'Other' data in graphs.

traingamer