ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I create a combination stacked & cluster column chart? (https://www.excelbanter.com/charts-charting-excel/81227-how-can-i-create-combination-stacked-cluster-column-chart.html)

fullerdb

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?

Jon Peltier

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/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" wrote in message
...
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?





All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com