Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2020, 11:39 PM
ganesang ganesang is offline Need to show percentage value in pivot chart instead of decimal value Windows XP Need to show percentage value in pivot chart instead of decimal value Office 2016
Competent Performer
Need to show percentage value in pivot chart instead of decimal value
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default 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
File Type: jpg 1_data.JPG (18.5 KB, 4 views)
File Type: jpg 2_chart.JPG (26.5 KB, 4 views)
Reply With Quote
  #2  
Old 03-23-2020, 07:22 AM
ArviLaanemets ArviLaanemets is offline Need to show percentage value in pivot chart instead of decimal value Windows 8 Need to show percentage value in pivot chart instead of decimal value Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

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!
Reply With Quote
  #3  
Old 03-23-2020, 09:40 PM
ganesang ganesang is offline Need to show percentage value in pivot chart instead of decimal value Windows XP Need to show percentage value in pivot chart instead of decimal value Office 2016
Competent Performer
Need to show percentage value in pivot chart instead of decimal value
 
Join Date: Jul 2018
Posts: 136
ganesang is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 03-23-2020, 11:55 PM
ArviLaanemets ArviLaanemets is offline Need to show percentage value in pivot chart instead of decimal value Windows 8 Need to show percentage value in pivot chart instead of decimal value Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

This time there wasn't even the need to format axis labels! (Probably because I started table creating with formatting column A as percent as 1st step.)

Btw, in your picture labels are aligned to left, what indicates they may be formatted as text. But on your chart percents converted to decimals - i.e. they are handled as numbers
Can it be that you entered/calculated label values as percents at start, and then formatted them as text. This may result in confusing effects, as some Excel features (like formulas) will handle such values in previous format until cells in range are updated. And some Excel features (like cell alignment) will handle them in current format. So whe your label values are formatted as text, but are really percents (i.e. numbers), then your chart reads label values text strings containing label values in General format (e.g. 30% will be 0.3), but you can't format axis, as you can't display text value as percent. (This is not a knowledge, but a hunch only!)

When labels are formatted as text currently, change the format to percentage, and go through all cells with percents hitting F2 (activating Edit) and then Enter. After that all values are formatted properly.

Added is example what I got.
Attached Files
File Type: xlsx ChartAxisFormat.xlsx (14.1 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need to show percentage value in pivot chart instead of decimal value Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM
Need to show percentage value in pivot chart instead of decimal value 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


All times are GMT -7. The time now is 10:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft