Thanks for the link - this is really helpful.
One thing though, I'd only like to change the color of the last column "%Actual to planned" not the whole table.
Any thoughts on how to do this?Thanks,
Please check my workbook attached. You need to add title and measure value based 6 containers in column.
First should be select and change to text. Select colour marks and color opacity to o.
select 2nd axis and select dual axis with text in both actual and planned.
Edit axis and change name to actual.
Do the same in all.
drag the color into final one and add it first as text and 2nd as square.Drag number of records to size and increase.
It's a little more complicated to do this than I hoped, but it solves the problem. thanks for your brainpower!
Check out my reply (I was working on it while Sankar was posting obviously). I think mine's a lot easier and simpler, but it depends on your use case which would suit better.