Results 1 to 10 of 10

Data Label Issue

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Data Label Issue

    Hello all. Thanks so much for your time.

    For the sake of simplicity, I'll use an analogy to pieces of fruit:

    I created a pivot chart to show the number of good and bad pieces of fruit and the corresponding tree that produced each type of fruit. Because some trees are "used" more than others and thus will tend to produce more bad fruit, I inserted two calculated fields in place of the existing fields in order to show what percentage of total # of fruits produced by each tree are bad/good. So the formula looks something like % bad fruit = (# bad fruit / (# bad fruit + # good fruit))*100 .

    Here's my issue: I would like to see the number of bad fruits (or maybe even number of total fruits) produced by each tree next to (preferably on top of) the bars that represent the percentage of bad fruit without graphing the number of bad fruits to add some sensibility to the data (i.e. if one tree has produced 100% bad fruit, but it has only produced a total of 5 fruits, the graph can be slightly misleading without closer inspection). Adding data labels doesn't accomplish this because it simply shows the percentages.

    I am fairly inexperienced with Excel, so forgive me if this is obvious. I appreciate the help.

    Here is a model of what I have (see attached file).

    - Zoo
    Attached Files Attached Files
    Last edited by zooropa33; 05-07-2014 at 06:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 100% stacked bar issue on data label
    By sarinky in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2013, 07:08 AM
  2. Chart Data Label/Secondary Axis Issue
    By pdub84 in forum Excel General
    Replies: 0
    Last Post: 12-20-2011, 12:54 PM
  3. Pie chart and percent data label issue
    By drewship in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-04-2009, 09:36 AM
  4. Data Label - Window Resize Issue
    By mdalby in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-13-2006, 09:03 PM
  5. Replies: 0
    Last Post: 10-06-2006, 09:05 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