Combine clustered column and stacked bar in excel 2003 or 2010

I have 2 data sets, I need to show a stacked & clustered column.

title      Pump1      Pump2      Pump3
Incidents      10      20      40
Volume      30      12      15
Staff      12      14      25
Pump1      Jan      Feb      March
Incidents      2      3      5
Volume      10      10      10
Staff      5      4      3

For example, Pump1/2/3 will be side by side as Incidents/volume/staff and for each of those bars they will be stacked based on how many of that type for that month.

Is this possible?
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:

Jon Peltier has a tutorial on clustered stacked charts here:

The devil is in the detail of the data layout. I'd be happy to help, but I have not quite figured out what you want on which axis and what you want to stack.

cheers, teylyn
cnrlzenAuthor Commented:
It's a bit of a hack solution, but will work. I just wasn't sure if Excel could do it out of box, but according to that link you need to buy a separate add-on to get that functionality.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
If it can be done with Excel charts, Jon can do it. He sells the automated VBA add-ins that make the process easier, but he also always shows the manual way of achieving the same thing for free on his site.

I agree, the approach is a bit cumbersome manually, especially for larger datasets, but the results are worth it.

Thanks for the grade,

cheers, teylyn
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.