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?
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?
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?
Originally Posted by shg
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.
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?
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 ?
Nvm, i got it working. Thanks very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks