Multi-axis chart

[tolomeo]

I'm having trouble while implementing a chart, i have two series (columns), one is related to left y axis and the another to y right axis (as i'm showing 5 years in the past and current year on left y axis and current year on right y axis).

The problem is that using clustered columns i'm not beeing able to "overlap" both columns, they are 50% wide each column, as i'll be showing only one of them, is it possible to overlap both series?

Any other aproach will be appreciated (i tried to do with stacked columns, but it won't work as i'm using 2 Y axis).

[HighAley]

Hello.

Maybe it's possible to create one Series will all data.
You could change colors of the bars using Conditions.

Thank you.