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

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!