Answered by:
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
TerryThursday, May 21, 2009 4:33 AM
Answers
-
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.- Marked as answer by Raymond-Lee Friday, May 29, 2009 9:14 AM
- Unmarked as answer by Raymond-Lee Wednesday, June 3, 2009 7:24 AM
- Marked as answer by Raymond-Lee Wednesday, June 3, 2009 7:25 AM
Friday, May 22, 2009 1:41 AM
All replies
-
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.- Marked as answer by Raymond-Lee Friday, May 29, 2009 9:14 AM
- Unmarked as answer by Raymond-Lee Wednesday, June 3, 2009 7:24 AM
- Marked as answer by Raymond-Lee Wednesday, June 3, 2009 7:25 AM
Friday, May 22, 2009 1:41 AM -
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.comThursday, October 8, 2009 10:15 PM -
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.Tuesday, October 27, 2009 4:39 PM