+ Reply to Thread
Results 1 to 6 of 6

Stacked bar graph with divided bar?

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Delft, Nederland
    MS-Off Ver
    2019
    Posts
    4

    Stacked bar graph with divided bar?

    Is it possible to have a stacked bar graph with one bar divided in two parts? An example is showed in the attachment with bar ‘C’. Or is there another way i should be approaching this?
    Attached Images Attached Images

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

    Re: Stacked bar graph with divided bar?

    Short but useless answer -- yes I'm confident that something like this is possible. I'm not aware of any "buttons" to push or "checkboxes" to select that will make Excel do this out of the box. It might require a stacked area chart (maybe using strategies like those used in creating Marimekko charts: https://peltiertech.com/marimekko-charts/ ) or some other "tricks" with stacked bar/columns and date axes and who knows what, but I'm confident it can be done.

    Can you share some actual numbers in a spreadsheet so we have something to work with?
    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
    03-23-2021
    Location
    Delft, Nederland
    MS-Off Ver
    2019
    Posts
    4

    Re: Stacked bar graph with divided bar?

    I was also looking into marimekko charts, but wasn't certain this would produce the wanted result. I'll attach a spreadsheet for more clarity. The goal is to have the 'C.2' bar included in/next to the 'C' bar in the graph.
    Attached Files Attached Files

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

    Re: Stacked bar graph with divided bar?

    I tried this for my first go:

    1) In I3 to AD3, I enter the numbers 1 to 22 (1/10th of the 220 total that is the combined C values).
    2) In I4, I enter a formula like =IF(I3<=20,SUM($D$4:$D$5),0)
    3) In I5, I enter the complementary formula =IF(I3<=20,0,SUM($D$4:$D$5))
    4) In I6, I enter =D6
    5) In I7, I enter =D7
    6) Select I4:I7 and copy/paste/fill across to column AD.
    7) Select I4:AD7 and insert a stacked column chart.
    8) Select any data series and format the series so that the gap width is 0.

    I end up with a stacked column chart where one of the stacks is split horizontally into 90:10 portions.

    There are several things to do to make it more flexible, but that should give the basic idea for my first attempt. What do you think?

  5. #5
    Registered User
    Join Date
    03-23-2021
    Location
    Delft, Nederland
    MS-Off Ver
    2019
    Posts
    4

    Re: Stacked bar graph with divided bar?

    The formula's don't work for me. There has to be an easier way to do this, right? I'm not sure where the fault lies. Will this method also work with other random ratios like 7450:130 ?

  6. #6
    Registered User
    Join Date
    03-23-2021
    Location
    Delft, Nederland
    MS-Off Ver
    2019
    Posts
    4

    Re: Stacked bar graph with divided bar?

    Nvm, i got it working. Thanks very much!!

+ 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: 08-24-2016, 04:15 PM
  2. Combine Line Graph & Stacked Column Graph
    By CGreenie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2015, 12:09 PM
  3. [SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph
    By Shearwater in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2014, 04:59 AM
  4. French format issue for Excel graph not divided by 1000
    By myowntest in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-16-2013, 01:52 AM
  5. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  6. [SOLVED] Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 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