John,
I had to do something very similar recently.
Have a look at Jon Peltier's excellent page and the links from it:
http://peltiertech.com/Excel/ChartsH...sterStack.html
Dave
"John" wrote:
Hi
I have three series; Income Target, Confirmed Income and Provisional Income.
I would like to stack Confirmed Income and Provisional Income on top of each
other to make combined income and then I want the Income Target next to it
so I can compare. Unfortunately as far as I can see charts either only stack
all series or place all of them side by side, they don't mix between
stacking and placing side by side. Is this correct or am I missing
something.
Regards