Need some help in Pivot Chart

[K Vinod]

Dear All,

I need the help in Pivot Chart to show the percentages on Bars which we are taking from the Pivot Table.

Is it possible to show the percentages as " 36% " like in this way?

When i am trying to do this in Pivot Chart it is showing as " 3600% ".

Kindly help me in getting this.

Your's
Vinod K

 

[K Vinod]

Dear All,

I need the help in Pivot Chart to show the percentages on Bars which we are taking from the Pivot Table.

Is it possible to show the percentages as " 36% " like in this way?

When i am trying to do this in Pivot Chart it is showing as " 3600% ".


Please check the attached file for your reference.


Kindly help me in getting this.

Your's
Vinod K

 

[Gregor]

Yes it's possible. This is just foramtting, but its easier if you attach the file rather than a screen shot.

Thanks

 

[K Vinod]

Dear Gregor,

If possible, Can you share me the file with percentage for reference to me with any data.

Vinod K

 

[Chihiro]

Do you want straight conversion from count to % (this will result in total being higher than 100%). Or % of Grand Total?

If % of Grand total. Right click on the field/column in PivotTable, ValueField Settings. Go to Show Value As, and choose "% of Grand Total".