I have two fields I would like to show in pie charts on a map.
I'm having trouble understanding how field 2 is represented as a part of field 1. If a polygon in field 2 is over half of field 1, why is it being shown as almost 1/4 of the pie chart? - confused!
For example - this pie chart is showing the light blue field as 80,000 and the dark blue field as 70,000
I read in the help files that it converts your data to map units, so it is showing field 2 based on its proportion of the size it has set as the scale. I think.
But anyway, it is misrepresenting my data...I need to show field 2 as half the pie chart if the figure is half of field 1. How to get around this? I've tried setting is as a ratio but it still doesn't look right.
nm I think I get it after reading excel help. What I need to do is convert fields 1 and 2 to a proportion of 100, so 80,000 would become 5 and 60,000 would become 4. Easy way to do this using field calculator?