PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting How can I create a combination stacked & cluster column chart?

Reply

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

 
Thread Tools Rate Thread
Old 03-04-2006, 04:09 PM   #1
=?Utf-8?B?ZnVsbGVyZGI=?=
Guest
 
Posts: n/a
Default How can I create a combination stacked & cluster column chart?


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
Old 03-04-2006, 06:22 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: How can I create a combination stacked & cluster column chart?

You can get this effect through staggering of the data, as described in the
links on this page:

http://peltiertech.com/Excel/Charts...usterStack.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" <fullerdb@discussions.microsoft.com> wrote in message
news:389CC1EB-3538-4143-BD72-484CB1809965@microsoft.com...
>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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off