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

		Microsoft Office Forums > Microsoft Excel > Excel
Need to show percentage value in pivot chart instead of decimal value

FAQ

Thread Tools

Display Modes

03-22-2020, 11:39 PM

ganesang

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

Office 2016

Competent Performer

Join Date: Jul 2018

Posts: 170

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

Hi Folks,

I can't change the axis value to a percentage in the pivot chart even I could change the NUMBER format in chart settings and that only showing as decimal value.

Please find the attached files for reference and let me know.

thanks in advance!!

Ganesan. G

Attached Images

	1_data.JPG (18.5 KB, 13 views)
	2_chart.JPG (26.5 KB, 13 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 AM.