Solved

Combine clustered column and stacked bar in excel 2003 or 2010

Posted on 2012-03-13
3
634 Views
Last Modified: 2012-03-13
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?
0
Comment
Question by:cnrlzen
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
Comment Utility
Hello,

Jon Peltier has a tutorial on clustered stacked charts here: http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

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
0
 

Author Closing Comment

by:cnrlzen
Comment Utility
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.
0
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
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
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now