• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Pivot pie Charting

Hello All,

I have few data points where in I need to insert a separate column for average of two variables.The average column is manually inserted.

I have a challenge in pie chart where in I have to show:

Each KPI Week wise Average ( Depends upon on number of KPI's in Header)
All KPI together total Average ( Different Pie chart)

The pie chart below is calculated from a table created separately not from pivot tables.

Any help on this is appreciated.

upload_2018-12-8_23-29-44.png
upload_2018-12-8_23-32-27.png
 

Attachments

  • Pivotchart.xls
    74 KB · Views: 3
Dinesh_Excel
a) average can get from Pivot
b) I modified a little Your Pie ... sorry

Could You continue from this sample?
 

Attachments

  • Pivotchart.xls
    77.5 KB · Views: 2
Thanks Vletm for the support.

the ask for me was to create only the "Total Value of Average of C Value and count of Ckey " in the pie.

But the challenge here is everytime a new KPI is added , we have to change range the new KPI accordingly.

I have added KPI K in the base and while refreshing the pivot the pie skips the same.

Please help.

upload_2018-12-9_1-5-28.png
 

Attachments

  • Pivotchart.xls
    93 KB · Views: 2
Dinesh_Excel
hmm...
You can show both values in one chart
and/or (copy & paste ... delete 2nd serie)
You can select ranges as in this ....
I refreshed ... and still looks same.
 

Attachments

  • Pivotchart.xls
    122.5 KB · Views: 11
Back
Top