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! |
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! |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com