Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Stacked & Clustered - 1091 - Learn Excel Podcast

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
10,284
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 31, 2009

Jeff from Akron asks how to create a column chart where two series are stacked, but a third series is clustered. Episode 1091 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (9)

Sign In or Sign Up now to post a comment!
  • 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.

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

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

  • doesnt work

  • 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

  • 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.

  • 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.

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

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

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more