View original (French)

Display a total on a pivot chart

aGauffrette Posted messages 3 Status Membre -  
tontong Posted messages 2575 Registration date   Status Membre Last intervention   -
Hello,

I'm looking to display a total on a pivot chart in Bar format. I have the data labels for each category (revenue) but I can't see the total, which is a shame. Does anyone have a tip?

Thanks in advance for your help.

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
Could you please specify whether you would like to display a single total for a bar graph or a total for each category with a stacked bar graph?
3
aGauffrette Posted messages 3 Status Membre
 
Hello,
I have my different bars for each category that I don’t want to stack but keep distinct. And I would like to have a box in my chart that gives me the sum of all the amounts.
0
Réponse 2 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
We assume the total in G20 in the pivot table.
In P2 we type = then click on G20.
The formula bar displays =GETPIVOTDATA(....) confirm.
Select the chart, type = in the formula bar and then click on P2 in the pivot table sheet, confirm.
The total appears on the chart in a text box (surrounded by small dots). This box can be moved. The total value will update with the pivot table.
0
aGauffrette Posted messages 3 Status Membre
 
Ah too bad it seemed pretty good... but I don't see the number showing up...
Well, it's not a big deal, I can add it in a box next to the graph! Thank you for your time.
0
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064 > aGauffrette Posted messages 3 Status Membre
 
This procedure was established with Excel 2003.
In fact, it is the same as for a regular chart, except that for a Gcd, you need to go through an intermediate cell (P2) from the pivot table that serves as a base.
0