Thanks for the links; by and large, they are using overlaying of the charts
as the fundamental technique. If there is no other way to create my chart, I
will resort to overlaying!

Debra, I did try to create the chart by staggering the data but I was unable
to come up with a category labeling scheme that the reader could understand.
You see, I need (a) the stack components to be identified as Product A, B.
and C, (b) the unstacked column next to it labeled 'Total Gross Margin" and
(c) the years 2001 and 2002 to be the X category labels, applying to both the
stacked and unstacked column next to it. If you honestly feel that overlaying
is the only option, please let me know and I'll stop looking for an
alternative.

Thanks for your help Debra and Earl.


"KG" wrote:


I have the following data set:

2001 2002
Sales Product A 45 55
Sales Product B 102 123
Sales Product C 66 78
Total Gross Margin 60 77

I want the sales to be in stacked columns and the gross margin a separate
column next to them, as it represents total gross margin for all three
products; 2001 and 2002 are the X category labels.
I can easily show the gross margin series as a line or area but when I
attempt to show it as a column, the entire chart is converted to clustered
columns. Is there a work-around?