Stacked & Clustered - 1091 - Learn Excel Podcast

[ccheider]

Can you add mulitple stacked & Clustered. I need to show 6 years of data with 5 schools showing money each school received from two different sources.

[amoyano9]

you are a life saver!! So easy, clear and helpful! much appreciation

[erickim77]

Thank you very much. It really helped me a lot with my report

[salmanrizvi7]

doesnt work



[manzarek74]

Hi am am interested also in another series of pair stack+cluster in same chart:

I mean another series 2a,2b, series 2ab added to the one above. Is it possible?

//thank you

[gcrydes]

This is great but like the last comment, I want to stack and cluster. I have series 1a, 1b, 1c through 6a, 6b and 6c. I'd like to stack 1a & 2a, clustered next to 3a & 4a, clustered next to 5a & 6a.

Repeat with 1b & 2b, clustered next to 3b & 4b, clustered next to 5b & 6b.

Repeat with 1c & 2c, clustered next to 3c & 4c, clustered next to 5c & 6c.

This would leave me three sets of three clustered columns each with two stacks.

How do I do that? Thanks.

[fellowgoodie]

After watching mulitple times I am able to understand.

Unfortunately however this takes a simple example of clustered-stacked bar chart. i.e a cluster of one stacked(with 2 data series) and one non-stacked(with 1 data series) bar chart.

Can you also show an example or post a video of multiple- stacked bar chart. There is one technique like peltier etc,but that is not explained free.

[albertliuu]

Now to use this to create 2 side by side stacked bars clustered...

[pirateofvizag]

You are the Man..! Thanks bill ..!You save my day..!