+ Reply to Thread
Results 1 to 9 of 9

Stacked bar (bar height equals larger value, not total)

  1. #1
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    39

    Stacked bar (bar height equals larger value, not total)

    I'm trying to make a stacked bar graph, wherein the smaller bar is placed within the larger bar. I'm struggling to explain this without a simple example, so here is what I mean:

    The total value is 10 pizzas sold. 8 were plain pizzas and 2 had toppings.

    In the typical format, one bar would be 8 and the other would be 2. The entire stack would equal 10.

    In my version, the bar height would only be 8, but the first two units would be a different color or pattern to represent the pizza with toppings. It would be implied that the height of the entire bar is the plain pizza (8 slices mmm).

    Thank you in advance for your advice on creating this in Excel 2013 version!

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

    Re: Stacked bar (bar height equals larger value, not total)

    Isn't that the same as a regular stacked bar where the bottom bar was 2 and the top bar was 6 (8-2)?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Stacked bar (bar height equals larger value, not total)

    Thanks for the quick reply!

    That's what I want to happen visually, but my default settings create a bar of 10 total units (a correct 8 to 2 split, but that's not our goal visually).

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,390

    Re: Stacked bar (bar height equals larger value, not total)

    Do you not have a column with a formula like =8-2 or equivalent? Charts don't really do data analysis or "change" the data in the spreadsheet. In most cases, if you want a value (the value 6 in this case) represented in a chart, that value needs to be in the spreadsheet somewhere. I would expect a spreadsheet that looks something like:
    Please Login or Register  to view this content.
    Then use column A and column C in the stacked bar/column chart. Is your spreadsheet amenable to something like that?

  5. #5
    Registered User
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013
    Posts
    75

    Re: Stacked bar (bar height equals larger value, not total)

    Is this what you want (?) - you can completely overlap the series by setting Series Overlap to 100%.

    EXCEL_2019-11-09_10-26-39.png
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Stacked bar (bar height equals larger value, not total)

    Quote Originally Posted by MrShorty View Post
    ...Then use column A and column C in the stacked bar/column chart. Is your spreadsheet amenable to something like that?
    Yes, that's a workable idea. I didn't think of just creating an additional column!


    Quote Originally Posted by Mrrrr View Post
    Is this what you want (?) - you can completely overlap the series by setting Series Overlap to 100%.

    Attachment 648906
    Yes - that works very well. Is there a way to make it a dual graph too? Such that we're comparing the plain and topping slices in one overlapped bar; then the plain and topping calzones in another overlapped bar on the same graph? If there is a way to represent that, I think this would be considered solved.

  7. #7
    Registered User
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013
    Posts
    75

    Re: Stacked bar (bar height equals larger value, not total)

    See if attached is ok.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    04-27-2017
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Stacked bar (bar height equals larger value, not total)

    Thank you, Mrrr. I'm ready to call this one solved.

  9. #9
    Registered User
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013
    Posts
    75

    Re: Stacked bar (bar height equals larger value, not total)

    Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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