ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   combination of stacked and clustered column (https://www.excelbanter.com/charts-charting-excel/504-combination-stacked-clustered-column.html)

Grigori Margolin

combination of stacked and clustered column
 
Hi!

Any ways to combine two types of chars: sgtacked columns and clustered
columns?

B.R
GmA



Debra Dalgleish

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/E...ps/Columns.htm

and Jon Peltier has links to other sites with information:

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


Grigori Margolin wrote:
Any ways to combine two types of chars: sgtacked columns and clustered
columns?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


John Mansfield

Grigori,

Here's another example that might help:

http://www.pdbook.com/index.php/exce..._column_chart/

----
Regards,
John Mansfield
http://www.pdbook.com


"Grigori Margolin" wrote:

Hi!

Any ways to combine two types of chars: sgtacked columns and clustered
columns?

B.R
GmA





All times are GMT +1. The time now is 08:39 PM.

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