Display Percentage for the Pie Chart

n_srikanth4
n_srikanth4 used Ask the Experts™
on
Hi  Experts,


      I have only  one column called as Issue_Status(Represented as New, Reopened, Implemented and Closed in a Pie chart ) having the Data series properties as follows. I have used the Stored procedure to implement the business rules and fetch the data.

1. Sum(Fields!New.Value)
2.Sum(Fields!Reopened.Value)
3.Sum(Fields!Implemented .Value)
4.Sum(Fields!Closed.Value)


Question : I am unable to display the pie in percenatage for the above mentioned status and I have no control when i use  the expression    " (#PERCENT{P1})" (or)   #PERCENT in the Series Label Properties.  The percentage is not consistent , some times it get displayed and some times it  won't.

Could you please explain and walk me through with an example how could I display the percentage for all the pies  in the Pie chart ???


Regards,

Sreekanth.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
HI,

Right-click on your chart.
Click on Properties
Click on "Data" tab
Click on Values once to highlight it
Click on Edit
Click on Point Labels
On "Format Code" box, enter 0.00%

and that should add % to your values.

Do it for all 4 that you listed above

Hope this helps

Author

Commented:
Hi SammySeltzer,

     I have tried this, but it won't work ..
BI Consultant
Most Valuable Expert 2011
Commented:
Hi Sreekanth,

I've explained this in one of my articles: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_1884-Pie-Chart-Techniques.html

Hopefully that helps you out?

Best regards,
Valentino.
Top Expert 2011

Commented:
hi n_srikanth4,

Just out of curiosity, what didn't work?

This is precisely the process we use here to add percentage to our charts.

Well, try Valentino's approach and hope it helps you out.

Author

Commented:
GOOD

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial