Barb,

Thanks for the quick response. This article came close but did not help me
because the items in the 2 series are different.

The chart I am trying to create has the exact same items in both series
(Sales by Region), only the values are different for actual and projected.
Maybe the answer is there and I need to improvise some.

Do you know of any other article that comes closer or some other web site I
could refer to?

TIA!
Robyda.



"Barb Reinhardt" wrote:

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!