+ Reply to Thread
Results 1 to 7 of 7

Unsolvable Problem? Glitch in the system?

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    Seattle, Washington
    MS-Off Ver
    Excel 2007
    Posts
    4

    Unsolvable Problem? Glitch in the system?

    Hello All,

    I have created a template that I input client data into. This data feeds into a pie chart. Most of the time the chart looks fine, but I am noticing that with certain clients, when I input their data, two of the pie slices will merge together. The border between the two slices disappears and they become the same color. (See "Correct Pie" attachment for the way it should be, and "Faulty Pie" to see how it looks when messed up.) The only way I've found to solve this is to change a few of the percentages by 1 or 2 thousandths of a percent, and then the chart corrects itself. For instance: I will have maybe 9-10 categories with different percentages that add up to 100% and my chart will be messed up. But if I change, say, 5% to 5.002%, 15% to 14.999% and change 10% to 9.999% it fixes itself. Both ways it adds up to exactly 100%, but with one set of data the chart is messed up, and another set it's fine. I find this very strange, almost like a glitch in Excel. The colors are not auto-generated, I have done a solid fill on each pie slice. Please help! I have asked everyone I know and checked all sorts of forums, with no one able to clear this up. Thanks!
    Last edited by NinthHour; 03-01-2013 at 04:49 PM.

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

    Re: Unsolvable Problem? Glitch in the system?

    Can you post a workbook example rather than pictures?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-28-2013
    Location
    Seattle, Washington
    MS-Off Ver
    Excel 2007
    Posts
    4
    Thanks for your help with this, Andy. Here's the excel file I am working with.
    Last edited by NinthHour; 03-11-2013 at 04:59 PM.

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

    Re: Unsolvable Problem? Glitch in the system?

    I could not create the problem with xl2010 but will check xl2007 on Monday, back at the office.

    Make sure your Excel has all the latest service packs and updates.

  5. #5
    Registered User
    Join Date
    02-28-2013
    Location
    Seattle, Washington
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Unsolvable Problem? Glitch in the system?

    Thanks, Andy. I checked and everything is updated, and I also opened this attachment again and it's still combining the cash and Fixed Income slices into one pie slice. Very appreciative of your help.

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

    Re: Unsolvable Problem? Glitch in the system?

    I can confirm the bug in xl2007 when rendering pie with 3d bevels.
    Use flat design to see slices. Better yet use a non pie chart style.

  7. #7
    Registered User
    Join Date
    02-28-2013
    Location
    Seattle, Washington
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Unsolvable Problem? Glitch in the system?

    Thank you so much for your help, Andy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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