Chart Manipulation

Hello,

What I am after is basically combining two types of graphs.

I have two different categories of data, planned and actuall, with numerous different projects for each one.

For example planned and actual project A, planned and actuall Project B, Planned and actual Project A.

I need these to be compared against each other with each project for planned to be in a stacked column being compared against the actual for each project in an attatched column for each month.

I have attatched an incredibly rough sketch of what I am after if what I have written is a little unclear.

Thanks

Hello,

Thats sort of what I'm looking for, but I need another set of data to be included.

Relating it to the example you showed me, where the pictures have the information showing year 1 year 2 year 3 etc, next to each year I would need another stacked column which read year 1 planned.

So along the bottom it would read Year 1 Planned, Year 1, Year 2 Planned year 2, Year Planned Year 3, and so on.

Thanks