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?