Hi,
I have a pivot chart that I have changed the data in the pivot table to % for Jan Q3 Score and Feb Q3 score but the chart seems to still display in numerical.
Appreciate assistance on how I can get the chart to display as % for Jan Q3 Score and Feb Q3 Score per the pivot table.
Re: Change Pivotchart Data To Percentage
If is used the same format for all the data it should work.
Concerning the Y axle, double left clik on it and select percentage for number type
Re: Change Pivotchart Data To Percentage
Hi,
How do I change the X axis to % as you have done ?
Re: Change PivotChart Numbers To Percentage
You should have nothing to do as far as ALL X's values are persentage, have a look between your file and the sent IN the Pivot Table.
Re: Change PivotChart Numbers To Percentage
Hi,
My apologies. I think I might not have been clear.
In my pivot table, I only need two data to be in % as below:
1) Jan Error Points >>This should be in normal numerical . Example is 1.25
2) Feb Error Points >>This should be in normal numerical . Example is 1.25
3) Jan Q3 Score >> This should be in %
4) Feb Q3 Score >> This should be in %
The pivot chart should be as per the pivot table above in which error point should be in normal numerical and Q3 score should be in %.
Based on the above, I changed data # 3 and 4 to % in the pivot table by right click>Numers>Percentage.
However, the chart still shows say example 0.9397 for Jan Q3 Score and Feb Q3 Score instead of % as per the pivot table , say example 93.97%.
Is there a way to do this ?
Re: Change PivotChart Numbers To Percentage
A proposal would be to used a copy of the Pivot Table with "classical" graph, Hum!!
Re: Change PivotChart Numbers To Percentage
Hi PCI,
I understand your solution.
Can you guide me how you did that ?
Re: Change PivotChart Numbers To Percentage
Just make a copy of the Pivot Table.
Start by the field: Enter a formula which make the copy of the First Cell Field: Here in E4 enter =A4
Then drag to cover the complete Pivot Table.
Note if you start by the Data Field you will have a GetPivotData formula which you don't need immediatly.
When the copy is done just launch the Chart Wizard.
When the chart is ready select it and right click to select Chart Option > Data Labels > Label
Double left click a label to select Alignment > Bottom
Select one by one the labels tou want to change: Double click to select and right clic to change the format.
Ouf! good luck.
Don’t have an account yet? Register yourself now and be a part of our community!
