none
How to show Percentages in Y axis in Stacked Bar Chart

Answers

  • Hi Thanneru,

    In chart data region, the values display on the Y-axis is depended on the aggregated values of the field added to the Values area.
    Based on your description, it seems that you want to display the percentage values of each series instance in the category group.  If so, please try to change the values expression of the value filed with following expression:
    =SUM(Fields!data.value)/SUM(Fields!data.value,”Chart_CategoryGroup”).
    (Note: the scope of the SUM function is the category group name)

    Then you can specify the number format to “Percentage” in “Vertical Axis Properties” dialogbox.

    The following screen shot shows the design structure and preview of a similar report. Please take as reference.


    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    Wednesday, November 21, 2012 9:52 AM