+ Reply to Thread
Results 1 to 4 of 4

Waterfall + stacked bar chart Excel issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Waterfall + stacked bar chart Excel issue

    Hello

    I am having some issues with inserting a "stacked" bar chart with an existing waterfall chart that I am using.

    in my attached template, you can see the waterfall chart is working fine, however, I cannot get the values in cell C17 and C18 to be stacked on top of each other.

    I am trying to show the 2015 YTD vs. 2014 Total + 2014 Other

    Can someone pls help?

    thank you.
    Attached Files Attached Files
    Last edited by jw01; 06-22-2015 at 03:38 PM.

  2. #2
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Waterfall + stacked bar chart Excel issue

    guys

    I have managed to add in the "stacked bar" portion, however i cannot seem to be able to remove existing bars w/o it deleting the entire set of data.

    in my ATTACHED, i need to remove the bars in "orange". i have stacked the bar in yellow and green, which is what I want to show, however, the bars in orange cannot be removed w/o deleting the other bars.

    help? thank you in advance.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Waterfall + stacked bar chart Excel issue

    Hello
    Not sure if this is it but take a look at the attached:

    DBY
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Waterfall + stacked bar chart Excel issue

    Oh wow that works perfect thanks so much!

    I was losing my hair over how to do it...didnt realize a range seperately would do it...still figure out what i was doing wrong in my second graph but thanks a million

+ 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. Monthly Headcount Change Stacked Column Waterfall
    By scampy74 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-15-2015, 03:56 PM
  2. How to do a Stacked Column Waterfall Chart with a Secondary Axis
    By Eric S in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-23-2015, 01:21 PM
  3. Stacked Area Chart Taper on/off issue
    By tonykslee in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 04-30-2014, 10:45 AM
  4. Stacked waterfall chart with horizontal line
    By kalam1989 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-28-2013, 12:42 PM
  5. Diverging Stacked Bar Chart issue
    By Lis7 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-23-2013, 07:00 PM

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