Chart with totals from the pivot table
nouhaaa1995
Posted messages
79
Status
Member
-
nouhaaa1995 Posted messages 79 Status Member -
nouhaaa1995 Posted messages 79 Status Member -
Hello,
when you create a Pivot Table, the grand total is automatically displayed. However, it does not appear as a series in a Pivot Chart. How can I get the grand total to show as a series in a Pivot Chart?
I tried selecting the data, but it's not possible in a Pivot Chart; you can't add to it.
Thank you for your help.
Have a great day.
when you create a Pivot Table, the grand total is automatically displayed. However, it does not appear as a series in a Pivot Chart. How can I get the grand total to show as a series in a Pivot Chart?
I tried selecting the data, but it's not possible in a Pivot Chart; you can't add to it.
Thank you for your help.
Have a great day.
2 answers
-
Indeed, it's impossible: Excel did not foresee this incongruous mix of elements and their subtotals in the same chart.
By removing the "date" field, you can obtain a GCD with the 3 parameter values.
You can add 3 subtotal rows in the database in Sheet1;
it will give you 3 more bars in the GCD
--
Retirement is nice!
Especially in the Antilles...
Raymond (INSA, AFPA) -
Yes, unfortunately
by adding to your idea, I thought that instead of creating a pivot table, we just needed to add a timeline that would allow us to choose the period we want to display.
Best regards.
