Ok, apparently Vicky's message didn't get sent to the list, and there
was a request for it. I couldn't get a forward to work, so here it is
(Vicky, hope you don't mind). I had to remove the attachments due to
size limitations.
AS WRITTEN BY VICKY BONWICK:
Alan,
Attached are a few jpegs of a possible solution.
I've made a few assumptions on what may exist at your end:
Assumptions:
1. You have a table of students as 'points' (or with a populated
district
column)
In my example each student could be one of three races
(Ethnicity = 1,2 or 3).
2. You have a table of districts as 'polygons' (structured as show: each
race must have it's own field to hold a 'count')
In my example districts are called A,B,C,D. (Pie charts need to
compare different fields across a table)
Method:
The trick is to populate the Race fields in the Districts table with the
'count' of students of that race.
1. Query the students table for Race1 (Ethnicity = 1) into Query1 2. Use
Update Column to update the Race1 field in the Districts table with the
'count' of students from Query1.
See example given in EthnicitySetUp.jpg (for updating for Race3)
Make sure the Join is set to "where object from table Students
is within object from table Districts.
3. Repeat for all Race# fields.
4. Pie charts should work as intended now.
Make sure they are a visible size (Styles>Pie Dimensions - Mine
came out to 1mm across initially)
Cheers
Vicky
Vicky Bonwick
GIS Consultant
Mbl: 0428 240258
PO Box 213
South Hobart
TAS 7004
Australia
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 13922
