Pie Charts

[dawnd3]

Hello,

I have a pie chart and would like to show value, percent AND label on the chart. However, Chart Options only allows me to show value, percent, label,OR label and percent together. I want to show all 3. Any ideas?

Thank you,

Dawn

http://www.calliopeconsulting.net

 

[JenWest]

Unfortunately, what I have done in the past is create text boxes to fill in the 1 missing piece, at each pie. I hope someone else can give you a better answer! JenWest

 

[dawnd3]

Great idea Jen. Does that work well if the data changes a lot? (i.e. the pie slices get bigger or smaller)

Dawn

http://www.calliopeconsulting.net

 

[JenWest]

No, not really, due to the fact that the text box gets filled in by me. Meaning I manually calculate the numbers and then type them in the text box!

 

[sxschech]

If the pie chart is placed as a subreport on a main report and the main report can be bound to a query, then you can create a dynamic text box on the main report that points to the value/format you need. Your text box then would be something like:

="Slice 5: " & Format([Slice5],"Percent&quot & " " & [Slice5]

Which would display:

Slice 5: 25% 300

Of course you would replace Slice 5 with the description, or omit if you don't need and then replace Slice5Total with the actual field name to use. Then apply your formating, whether PCT Label or Value. You may need to use format masks instead of "Percent" if result doesn't display as you want.

 

[dawnd3]

well I actually found out that this guy has XP (I have 2000) and in XP it allows you to pick all 3. I appreciate all the help.

Dawn

http://www.calliopeconsulting.net