topic Re: Pie chart labels in State & Local Government Questions

Pie chart labels

ELTerrell — Tue, 16 Jun 2015 20:34:42 GMT

Hi,

I just created a map with pie charts representing points and their %'s of Dems, Reps, and UNA's. I was wondering if there is an easy way to create labels which are the percent of each site. For example I'd like for a pie chart's label to say 50% D, 25% R, 25% UNA. Any thoughts on how this could be easily done? Other than adding text for each one...

Re: Pie chart labels

SepheFox — Tue, 16 Jun 2015 20:59:50 GMT

Yes, you could create a label expression for your point feature class. In the label properties for the layer, click on the expression button, leave it in the default vbscript, and enter this in the box:

[DemField] & "% D" & vbCrLf& [RepField] & "% R" & vbCrLf& [UNAField] & "% UNA"

(You will need to change the text in the square brackets to your field names)

Re: Pie chart labels

ELTerrell — Wed, 17 Jun 2015 12:23:17 GMT

When I do that, it gives me the whole number of voters at the site as a percent i.e. 415%D, 500%R, 300%UNA. Am I doing something wrong? Would it be simpler to change my spreadsheet to include the percent at each site instead just the whole number?

Re: Pie chart labels

SepheFox — Wed, 17 Jun 2015 13:53:51 GMT

Ok, it wasn't clear that your fields contained whole numbers, you only talked about percentages. Yes, you should add fields to calculate the percentages into, by putting in field calculator something like: ([DemField]/([DemField]+[RepField]+[UNAField]))*100. Then use the percentages fields to create your label expression. You could do the calculation in the label expression, but I'd do it in separate fields first.

Re: Pie chart labels

ELTerrell — Thu, 18 Jun 2015 14:17:57 GMT

That worked, thanks! Is there a way to uncouple the %'s so I can put each label in it's respective pie slice? Kind of like when you convert a legend to graphics, uncouple, and edit.

Re: Pie chart labels

SepheFox — Thu, 18 Jun 2015 14:40:46 GMT

The only way I can think of to do that, would be to have three copies of the layer (two can have no symbology), label each one with a different field, convert to annotation, and then edit the annotation. Kind of a lot of work though. At that point you might as well add the text yourself.

Re: Pie chart labels

ELTerrell — Thu, 18 Jun 2015 17:59:55 GMT

Yeah, that's what I was thinking. Thanks!

Re: Pie chart labels

SepheFox — Thu, 18 Jun 2015 18:12:07 GMT

You're welcome. If this answered your question, would you mind marking it as answered? Thank you!