PC Review


Reply
Thread Tools Rate Thread

How can I create a combination stacked & cluster column chart?

 
 
=?Utf-8?B?ZnVsbGVyZGI=?=
Guest
Posts: n/a
 
      3rd Apr 2006
I am trying to create a clustered column chart. However unlike a standard
clustered column chart I want one (and only one) of the columns to be a
stacked column made up of two data sources. The other two columns would be
standard columns made up from just one data source. Is this possible?
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      3rd Apr 2006
You can get this effect through staggering of the data, as described in the
links on this page:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"fullerdb" <(E-Mail Removed)> wrote in message
news:389CC1EB-3538-4143-BD72-(E-Mail Removed)...
>I am trying to create a clustered column chart. However unlike a standard
> clustered column chart I want one (and only one) of the columns to be a
> stacked column made up of two data sources. The other two columns would
> be
> standard columns made up from just one data source. Is this possible?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - Combination chart: Stacked Column + Stacked Column Robyda Microsoft Excel Charting 3 24th Aug 2008 03:16 PM
Create a combined Cluster and Stacked Column Chart? mmckinlay Microsoft Excel Charting 1 3rd Jun 2008 08:28 PM
How do I create a combined 'cluster' and 'stacked' column chart? =?Utf-8?B?TUI=?= Microsoft Excel Charting 1 8th Nov 2007 09:04 AM
How do I create a stacked column/line chart combination? =?Utf-8?B?Q29yaQ==?= Microsoft Excel Charting 3 2nd Aug 2006 03:23 AM
Creating a combination chart using cluster column & stacked bar t. =?Utf-8?B?aHJ1c3NlbGw=?= Microsoft Excel Charting 1 1st Nov 2004 12:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.