asked on

Display Percentage for the Pie Chart

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.

sammySeltzer

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

n_srikanth4

ASKER

Hi SammySeltzer,

I have tried this, but it won't work ..

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sammySeltzer

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.

n_srikanth4

ASKER

GOOD