+ Reply to Thread
Results 1 to 3 of 3

Pie of Pie Chart. 'Other' Value?!?!?! How to eliminate?

  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    27

    Question Pie of Pie Chart. 'Other' Value?!?!?! How to eliminate?

    My goal is to show the total internal and external totals on the left pie and then the value of each category on the right side. But where is this 'Other 50%' coming from?? I would like to eliminate this value please.

    pie of pie chart.jpg

    Thanks!

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Pie of Pie Chart. 'Other' Value?!?!?! How to eliminate?

    Well, it looks like the other data is Code 85, Code 15, Inbound Scan, RLTO, IDST, and No Scan at Parent hub.... Those are all being included in your pie chart. You need to adjust the data reference of the chart.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Registered User
    Join Date
    03-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Pie of Pie Chart. 'Other' Value?!?!?! How to eliminate?

    Sorry im a noob at this, but when doing a pie to pie, i was shown to select the series, format selection and then choose the number of value i want shown in the other pie. So i choose a value of 6, showing me the Code 85, Code 15, etc. Pretty much the Internal and External Totals are totals of those categories.

+ 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