#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
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 |
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 |