+ Reply to Thread
Results 1 to 3 of 3

Adding more data labels to pie chart

  1. #1
    Registered User
    Join Date
    06-24-2010
    Location
    Brookings, SD
    MS-Off Ver
    Excel 2007
    Posts
    2

    Adding more data labels to pie chart

    Greetings,

    I have a pie pivot chart with 5 categories showing the percentages of each category from the total. These categories represent a range of values from my data set. I would also like to include the average value of each category, as well as some other statistics from the set - to be included in the chart.

    I have attached a screenshot of what I have. What I would like to do is have the additional data in the table to be included in the chart simply displaying the values.

    After looking over the rules, I noticed that you would prefer to see actual excel files, rather than screenshots, so I am attaching a copy of the workbook
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by ctolson; 06-24-2010 at 03:32 PM. Reason: adding attachment

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Adding more data labels to pie chart

    You will need to build the chart data based on the pivot table.
    This way you can create category names that are a concatenation of the Category/Percent/Average.

    It is possible with some heavy altering of the pivot chart to get the average values displayed but not as part of the data labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-24-2010
    Location
    Brookings, SD
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Adding more data labels to pie chart

    Thanks for the tip, that works perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1