1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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

Discussion in 'Discuss Data Visualizations and Charting' started by Dinesh_Excel, Dec 8, 2018.

  1. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    136
    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

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,429
    Dinesh_Excel
    a) average can get from Pivot
    b) I modified a little Your Pie ... sorry

    Could You continue from this sample?

    Attached Files:

  3. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    136
    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

    Attached Files:

  4. vletm

    vletm Excel Ninja

    Messages:
    4,429
    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.

    Attached Files:

  5. Dinesh_Excel

    Dinesh_Excel Member

    Messages:
    136
    Thanks Vletm ...this is more presentable...thank you very much.
    I really appreciate your help here

Share This Page