Three bars with one Y axis

[fml55555]

Hi Gurus,

I have a requirement where I have to display three different data items on a chart and I want them to be contained within each other. This means that if the data items ate sales, direct costs and indirect costs, I want a bar for sales (lets say $200). Within this bar I want the direct costs (lets say $50) and within this I want the indirect costs (lets say $20) for an x axis of years.

So the sales will be a bar which would be wider, the direct costs would be less thicked and indirect costs would be thinner still.
I am able to have them side by side (e.g. x axis year 2009 has three bars sales, direct costs and indirect costs to be side by side, but not the same point and thus I am unable to make the bars contain each other).

I have tried using the combination chart, but one of the bars is always related to secondary axis which does not allow the user to understand the proportion of cost just by glancing at the report.

Is there any way of achieving it?


Thank you!