Need to show percentage value in pivot chart instead of decimal value

ArviLaanemets · #1 03-23-2020, 07:22 AM

Right-click below x-axis (on part with axis labels) and select Format Axis;
In Format Axis popup window (probably at right of screen), expand NUMBER;

In Category selection select Percentage. Set decimal places to 0.
Done!

ganesang · #2 03-23-2020, 09:40 PM

Hi ArviLaanemets

Thanks for the reply!!

I have tried this option already as mentioned in my post.

But still showing as decimal value.

Thanks
Ganesan. G

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting difference in time as a decimal and percentage of an hour	shabbaranks	Excel	2	05-23-2017 07:22 AM
Show percentage of results in a Pivot table	rogelinepaula	Excel	0	11-22-2015 06:58 PM
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Charts - Percentage & Number on same chart	thesiger	Excel	3	08-20-2015 07:31 AM
Can you add percentage (%) columns to a pivot table?	New Daddy	Excel	2	11-23-2013 09:49 PM