locked
Pie Chart point label show both value and name RRS feed

  • 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

    Thursday, 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.com
    Thursday, 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