+ Reply to Thread
Results 1 to 2 of 2

Pie Chart Display Issue

  1. #1
    Forum Contributor
    Join Date
    06-23-2010
    Location
    Iowa, United States
    MS-Off Ver
    Excel 2007
    Posts
    145

    Pie Chart Display Issue

    Hello all,

    I am having a frustrating time modifying the aesthetics of a pie chart. I have attached a workbook as an example. Within the workbook are two pie charts based off the same data set.

    The first uses the default multi-color simple display. All is well here. In the second, I changed the default display to a more flashy version per my boss's request. When doing this, the pie chart for some reason displays two pies. One with the correct color schemes and one on top with only two colors. I have spread out the pie pieces on the second example to show you what I mean. Does anyone have any idea why this happens or how to fix it? Thanks!

    Steve
    Attached Files Attached Files
    A VBA novice, excited to learn!

  2. #2
    Forum Contributor
    Join Date
    06-23-2010
    Location
    Iowa, United States
    MS-Off Ver
    Excel 2007
    Posts
    145

    Re: Pie Chart Display Issue

    I figured it out. One of my categories contains a zero. When I change this a nonzero value, the pie chart is back to normal. It would be nice if there is another work around other than subbing in a false low number, but if it works, it works.

    Steve

+ 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