View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I combine stacked and clustered chart types?

I have a detailed tutorial here (partially inspired by Bernard's example):

http://peltiertech.com/WordPress/clu...column-charts/

From this page I link to a utility that builds them for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Bernard Liengme" wrote in message
...
I believe this page will help
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kate" wrote in message
...
I have data broken out by month (x-axis) and I want to provide quantity &
value columns for each month (using primary & secondary axis). Then I
need
each column (quantity & value) broken out by region. I if I use the
stacked
column chart, the quantity & value columns lay on top of each other. I
need
them side by side like the clustered column chart. But the clustered
column
chart won't allow me to show the region breakdown of each column.