+ Reply to Thread
Results 1 to 5 of 5

Pie Chart exploding

  1. #1
    Registered User
    Join Date
    01-07-2008
    Posts
    37

    Pie Chart exploding

    I have two separate (though related) issues regarding Excel pie charts, but am filing them separately to keep responses straight.

    When exploding a pie segment from the main pie chart, I have noticed that the main body shrinks while the exploded segment withdraws. It, too, shrinks slightly, but not as significantly as the body.

    I recognize that Excel charts were designed for static display, not real-time animation using VBA, so this is a fact of life I must live with and adapt to. However, I know there is an incredible list of methods and properties for Excel charts, and I'm wondering if anyone with wider experience than mine has encountered something that might assist here.

    I have played with adjusting the size of the plotarea, trying to keep the size of the main pie the same as it shrinks in proportion. That turned out to be very complicated and I could find any that would tell me what the actual diameter of the pie itself was to maintain its apparent size.

    So, can this be done, or should I just accept the standard functionality?

    Suggestions, por favor? I appreciate the help.

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013; 365
    Posts
    221

    Re: Pie Chart exploding

    Attaching a sample Excel file might help.
    To show your appreciation
    Click ★ Add reputation!

  3. #3
    Registered User
    Join Date
    01-07-2008
    Posts
    37

    Re: Pie Chart exploding

    Okay. Try this one. Open it and press the red/orange button. That will demonstrate the effect I'm trying to overcome.

    Thanks
    Attached Files Attached Files

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

    Re: Pie Chart exploding

    Switch to non 3d pie and the problem will go away
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    01-07-2008
    Posts
    37

    Re: Pie Chart exploding

    FASSinating. Yes, testing on my original worksheet shows that the main pie stays the same size during all explosions and collapses when using a flat image. Not exactly the solution I was hoping for.

    *Sigh* My only complaint would be cosmetic. The 3D chart has more visual appeal (aside from the shrinkage issue). I think it depends on which my users would prefer. I should be able to offer both as an option.

    I'll have to run further tests to see if it also contributes to a solution for my other post on this topic.

+ 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. Exploding out rows depending on dates
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2017, 12:27 PM
  2. Replies: 2
    Last Post: 11-17-2015, 06:00 PM
  3. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  4. [SOLVED] shortcut key for exploding a cell in pivot table
    By aganesan99 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-09-2013, 08:03 AM
  5. [SOLVED] Exploding pie chart
    By Mary in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-13-2006, 09:25 PM
  6. Replies: 2
    Last Post: 06-13-2006, 05:15 AM
  7. [SOLVED] exploding a pivot table column into sheets?
    By Greg Loriman in forum Excel General
    Replies: 1
    Last Post: 12-22-2005, 08:10 AM

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