+ Reply to Thread
Results 1 to 3 of 3

Pie Chart - Display Groups of data as "Other"

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pie Chart - Display Groups of data as "Other"

    Hi there,

    I'm not new to excel but I am starting to use more advanced features of it and I'm a little stuck.

    I am trying to create a pie chart with large amounts of data as a percentage, rather than having all bits of data in the pie chart and lots of 0% data, is it possible for me to group bits of data and display it as "other" and how the percentage?

    Thanks

    T

  2. #2
    Registered User
    Join Date
    09-20-2012
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pie Chart - Display Groups of data as "Other"

    Hi T,

    Easiest way is to make a table in between grouping the different percentage as you see fit, either by using search strings or basic adding values (+).

    Romkedj

  3. #3
    Registered User
    Join Date
    09-24-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Pie Chart - Display Groups of data as "Other"

    Would that be possible if I have data like this:

    Data 1 - 50%
    Data 2 - 25%
    Data 3 - 15%
    Data 4 - 5%
    Data 5 - 1%
    Data 6 - 1%
    Data 7 - 1%
    Data 8 - 0.5%
    Data 9 - 0.5%
    Data 10 - 0.5%
    Data 11 - 0.25%
    Data 12 - 0.25%

    This is only an example, my actual data has a lot more data and percentages.

    Sorry to be thick.

+ 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