Combo Stacked column/column/line

I need to create a chart that shows series 1 & 2 as a stacked column, series
3 as it's own column, and series 4 as a line on a different axis.

Example:

I sell series 1 under my name
Another person sells series 2, but it is considered my business.
I want those 2 elements to be stacked so I can see total business I am
getting credit for, and breakdown between who seels how much

Series 3 is total company sales (coulmn)
Series 4 is the percentage of my sales vs total sales.

Can this be done?

Have a look at
http://peltiertech.com/WordPress/clu...column-charts/
and
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"TGags" wrote in message
...
I need to create a chart that shows series 1 & 2 as a stacked column,
series
3 as it's own column, and series 4 as a line on a different axis.

Example:

I sell series 1 under my name
Another person sells series 2, but it is considered my business.
I want those 2 elements to be stacked so I can see total business I am
getting credit for, and breakdown between who seels how much

Series 3 is total company sales (coulmn)
Series 4 is the percentage of my sales vs total sales.

Can this be done?