+ Reply to Thread
Results 1 to 2 of 2

Stacked charts

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    72

    Stacked charts

    I have a two bar chart (red and blue) I'm trying to turn into a stacked chart. It has total cars and broken cars. There are a 100 total cars (10 broken). But when I stack them, it shows 110 total cars (it's adding instead of merging them). Once stacked, there should still be 100 total cars....but the tip of it should be red to show what amount is broken. Does this make sense? It's adding the two together but it shouldn't....the number of broken cars is still part of the total. Can anyone help?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Stacked charts

    It seems to me that the easiest way to do this might be to simply add a helper column/row that will calculate the number of "unbroken" cars =total cars-broken cars (should be 90 in your example). Then, in your stacked column chart, plot broken and not broken.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. column charts: stacked / non stacked hybrid ??
    By littlejimmy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-24-2012, 11:36 AM
  2. Excel 2007 : Stacked charts
    By ChiotM in forum Excel General
    Replies: 2
    Last Post: 06-10-2011, 03:47 AM
  3. stacked bar charts
    By Alan Burton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2005, 08:50 AM
  4. Stacked 3D Bar Charts
    By jmoon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-22-2005, 06:05 AM
  5. Stacked Pie Charts
    By Athalie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-28-2005, 01: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