Clustered Column Chart Containing Stacked Data

C

Connie

Is it possible to develop a clustered column chart in Excel 2007 that
contains stacked data?

I am trying to plot the following data


Monetary Compensation Non-Monetary Compensation
Shipboard Shoreside Shipboard Shoreside
Dec 08 $125,000 $75,000 $50,000 $30,000
Jan-09 $145,000 $85,000 $40,000 $20,000
Feb 09 $150,000 $100,000 $60,000 $30,000

I would like to produce a chart which shows by month (horizontal
axis), monetary compensation compared to non-monetary compensation
(side by side columns - this is the clustered piece). I'd like to
stack each column to show the breakdown of shipboard versus
shoreside. Does anyone know if this is possible? Thanks so much for
your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Excel produce a clustered and stacked column chart? 2
How do I combine stacked and clustered chart types? 2
Using VBA to swap between a clustered or separated column chart 4
Clustered-Stacked-Column Combo Chart With Lines 2
Clustered and Stacked Column Chart 2
Dynamic Chart Title With 3D Stacked Column Chart 2
Needed: Chart that combines clustered column and stacked column types 3
Clustered column chart with stacked coumns 1

Top