Forum Discussion

Deleted's avatar
Deleted
Apr 13, 2018

grand total in pie chart of pivot table

Hello,

 

I want to display "Grand Total" column data in pie chart but currently it is displaying data from first column.

Pie chart should values from grand total column.

 

I have attached excel file.

Kindly help!!

 

Thanks

Charting
Excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 14, 2018

    Hi Kinjal,

     

    To my knowledge it's not possible to create Pivot Chart directly on Grand total column. Workarounds could be to add calculated field which shows the same as Grand total and use it for the chart. Or using cube function GETPIVOTDATA to generate dynamic table and use it for the chart.

     

    That question appears from time to time, you may google for sample and/or more details.

Resources