+ Reply to Thread
Results 1 to 4 of 4

Stacked Bar Chart with negative values, and the net total matters!

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Stacked Bar Chart with negative values, and the net total matters!

    Hi!

    I am trying to create a stacked bar chart with quarterly data for multiple categories, that add up to a total for the quarter. I have some negative values in the data and I realize that stacked bar charts don't really support negative values (at least I think ). Is there a way to get around this? Someone has suggested a waterfall but I want all categories in ever time period. If anyone has any ideas I would really appreciate it!

    Thank you!
    Attached Files Attached Files
    Last edited by shannon2244; 09-21-2012 at 05:36 PM.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Stacked Bar Chart with negative values, and the net total matters!

    How about multiple waterfall charts next to each other? I have one spreadsheet I maintain for weekly reporting that I use a waterfall chart for multiple items that I want to be compared on the same scale and just set fixed values for the the y-axis so the visual of the size of each bar is similar to how it would appear if they were on the same chart.

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Stacked Bar Chart with negative values, and the net total matters!

    That sounds like exactly what I need! Would you be willing to post an example? Thank you!

  4. #4
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Stacked Bar Chart with negative values, and the net total matters!

    You'd want to replicate this for each quarter.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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