Pie Chart point label show both value and name

Question

Hi Everyone,


I'm trying to complete a report with a pie chart,  that need to show label with the catagory type name, and formarted percent value (%),  so there are displays both value and name,  e.g. point label show:  "TypeNameX1 26.30%" , I have tried to do the same in a chart with reporting services 2008 without any luck.

Any help will be appreciated in this problem.


Thanks

Terry

Answer 1

The following information about chart data point label "keywords" may help achieve the desired labels.

HTH,
Robert

Supported Keyword List

The chart control support multiple Y values and all related keywords use the first one by default but also can be used with additional Y values. For example:

“High=#VALY/nLow=#VALY2/nOpen=#VALY3/nClose=#VALY4”

An optional format string can be added at the end of each keyword.  You can find more about possible format strings from here: http://msdn.microsoft.com/en-us/library/427bttx3.aspx Below is an example of using standard currency format and custom format string:

“Price= #VALY2{C0}/nAverage Price = #AVGY2{C0}/nVolume = #VALY3{#,,.;(#,,.);0}”

Keyword	Replaced By	Supports Multiple Y Values	Supports Formatting String
#VALX	X value of the data point.	No	Yes
#VALY	Y value of the data point	Yes	Yes
#SERIESNAME	Series name	No	No
#LABEL	Data point label	No	No
#AXISLABEL	Data point axis label	No	No
#INDEX	Data point index in the series	No	Yes
#PERCENT	Percent of the data point Y value	Yes	Yes
#LEGENDTEXT	Series or data point legend text	No	No
#CUSTOMPROPERTY(XXX)	Series or data point XXX custom property value, where XXX is the name of the custom property.	No	No
#TOTAL	Total of all Y values in the series	Yes	Yes
#AVG	Average of all Y values in the series	Yes	Yes
#MIN	Minimum of all Y values in the series	Yes	Yes
#MAX	Maximum of all Y values in the series	Yes	Yes
#FIRST	Y value of the first point in the series	Yes	Yes
#LAST	Y value of the last point in the series	Yes	Yes

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Robert, where did you get that list of keywords? Is it on MSDN somewhere?

Thanks!

---

-- Tyler Mitton http://www.rippleaudio.com __________________________________ Need Background Music? Buy & Sell Audio @ http://www.rippleaudio.com

Answer 3

Hello Tyler,

the list of keywords can also be found on MSDN here: http://msdn.microsoft.com/en-us/library/bb677551.aspx

HTH,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.