+ Reply to Thread
Results 1 to 4 of 4

Pie chart with categories and pulled slices

Hybrid View

  1. #1
    Registered User
    Join Date
    02-03-2009
    Location
    Virginia Beach, VA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Pie chart with categories and pulled slices

    Is it possible to make a pie chart like this with categories and pulled slices? I need to keep the slices together that are in the same categories.

    PieChartCategories.jpg

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

    Re: Pie chart with categories and pulled slices

    Not with a single chart. You can not explode AND reposition slices.

    You would need 3 separate charts.

    An alternative is a pie/donut combination where the donut ring imparts the grouping.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-03-2009
    Location
    Virginia Beach, VA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Pie chart with categories and pulled slices

    Funny, I did something very similar to that, but my boss didn't like it. He saw a chart like the sketch I drew up in a magazine and thought I could do it in excel. Funny, I wonder what software the desktop publishers are using that can do this, where excel can't?

    Thanks for the suggestion though, Andy!

    Skip

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

    Re: Pie chart with categories and pulled slices

    I would image it's just shapes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort pie chart slices
    By Jewelrose in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-04-2021, 10:25 AM
  2. Re-order pie chart slices
    By dalewms2 in forum Excel General
    Replies: 2
    Last Post: 10-08-2011, 08:06 AM
  3. VBA to push out pie chart slices
    By cpopham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2008, 12:11 AM
  4. [SOLVED] Pie chart slices too thin
    By Fred Smith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2006, 12:35 AM
  5. [SOLVED] Pie Chart Colouring - for top surface of slices only
    By Suz Campbell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-18-2005, 11:05 PM

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