+ Reply to Thread
Results 1 to 2 of 2

Stacked Bar Chart where Sum of Parts Does Not Equal the Whole

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Stacked Bar Chart where Sum of Parts Does Not Equal the Whole

    I'm attempting to create a stacked bar chart where the sum of the parts doesn't equal the whole. For example, say the entire bar would be 50, but the individual values that make up the value are 3, 7, and 10. This is for a net promoter score, where the score is a factor of positive, neutral, and negative responses. I want to indicate of the score (50), there were 3 positive, 7 neutral, and 10 negative. Any ideas how I would manage this?

    Thanks in advance!

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

    Re: Stacked Bar Chart where Sum of Parts Does Not Equal the Whole

    Can you post an example of the output you expect to see. Maybe include a few more examples of values and score.
    Use shapes to mock up the required output.
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  2. divide list into equal parts
    By robotlust in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2008, 11:28 PM
  3. [SOLVED] How can I combine a stacked bar chart with stacked colum chart?
    By Sin in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-19-2005, 11:55 PM
  4. [SOLVED] ?make a combo chart with 1 stacked bar and 1 not stacked, + show t
    By y in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  5. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 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