+ Reply to Thread
Results 1 to 7 of 7

Pie Chart - Adding 2nd data label series?

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    australia
    MS-Off Ver
    excel 2007
    Posts
    7

    Question Pie Chart - Adding 2nd data label series?

    Gday,

    I have data which needs to be represented by the percentage area it covers over a given region AND by the number of individual instances it occurs within the same region (e.g. within a region - what is the total area covered by wetlands (1st data series) and how many individual wetlands are there (2nd data series).

    I want to represent this on a PieChart - each wedge representing a 'wetland type', wedge size representing 'percentage area covered by that wetland type', and label representing 'number of individual wetlands of that given type'.

    I am using Excel 2007, and cannot see any options for doing this.

    Cheers in advance for any advice/help

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

    Re: Pie Chart - Adding 2nd data label series?

    Can you post example of your data and current chart
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-18-2009
    Location
    australia
    MS-Off Ver
    excel 2007
    Posts
    7

    Re: Pie Chart - Adding 2nd data label series?

    Data and example chart attached.

    Note that I am aware i can change the labels manually, but I need to do this for potentially hundreds of graphs, so would prefer a more automated solution

    Wetland_PieChart.JPG

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Pie Chart - Adding 2nd data label series?

    Data and example chart attached.
    No it's not. You attached a picture. Which requires that the expert here needs to type it all up again to test suggested solutions. Posting the actual Excel file off which you took the screenshot would be much more usable.

    Does your data mean that 23 wetlands A cover 10% of the area? Or is the %area column just dummy data for this example, and in your real chart represents the percentage that 23 is in the overall picture? That would make a big difference in suggesting a solution.

  5. #5
    Registered User
    Join Date
    06-18-2009
    Location
    australia
    MS-Off Ver
    excel 2007
    Posts
    7

    Re: Pie Chart - Adding 2nd data label series?

    Apologies, workbook attached this time.

    There are no dummy columns, only dummy data. The columns are exactly as i have it within my original worksheet, and are required to show all of the data i need to represent. The graph is graphically showing exactly the way i want it to, barring the labels which need to come from a separate column (see workbook).

    Yes, 23 'wetlands A' cover 10% of the area, 5 'wetlands B' cover 20% of the area etc.

    Further explanation in the workbook.

    Wetland_PieChart.xlsx
    Last edited by Bjornago; 01-19-2010 at 01:43 AM.

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

    Re: Pie Chart - Adding 2nd data label series?

    Simplest way is to use this free addin which links data labels to cells
    http://www.appspro.com/Utilities/ChartLabeler.htm

    You can not do it with another series as pie charts use category labels in the legend rather than series names. Adding another series causes the chart to revert to displaying series names in the legend. So the Wet A, Wet B etc would be removed.

  7. #7
    Registered User
    Join Date
    06-18-2009
    Location
    australia
    MS-Off Ver
    excel 2007
    Posts
    7

    Re: Pie Chart - Adding 2nd data label series?

    Cheers! Thankyou very, very much... perfect!

    Just saved me hours/days of manual work

+ 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