Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clustered Column Chart Containing Stacked Data
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clustered Column Chart Containing Stacked Data
Here's a tutorial:
http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Connie" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clustered and Stacked Column Chart | Excel Discussion (Misc queries) | |||
Stacked/clustered column chart with a two vertical axes | Charts and Charting in Excel | |||
Combined: Clustered-Stacked Column Chart | Charts and Charting in Excel | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel |