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

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!


Why not create a chart with two series (actual and projected) on the
same y-axis?