View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Excel 2003 - Combination chart: Stacked Column + Stacked Column

Jon Peltier has a nice step by step procedure for this here

http://peltiertech.com/Excel/ChartsH...sterStack.html
--
HTH,
Barb Reinhardt



"Robyda" wrote:

Is there a way to show 2 series as 2 stacked columns on 1 chart?

For example -

x-axis = quarters of the year: Q1, Q2, Q3, Q4

left y-axis = projected sales by region as a stacked column

right y-axis = actual sales by region as a stacked column

Regions = America, Europe, EMEA, APAC

This chart can help get a quarterly comparison of projections vs actuals by
quarter and region.

Thanks!