KG,

Seems to me Stephen Bullen has an example of that at
http://www.bmsltd.ie/Excel/Default.htm. It's in one of the "Charting
examples" downloads.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"KG" wrote in message
...

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?