Excel chart help

[JRCBoston]

I am trying to create a chart that has 3 data series and 3 Y-axes. I realize this may not be possible, but wondering if there is a creative workaround. My current chart has a stacked line chart which uses the left axis and I have "recession bars" using the right axis. I want to add a third data series using a different scale from the other two axes. Can something like this be done? Thank you.

 

[bobsan42]

I would make 2 charts make the second one transparent (Chart and Plot areas) and put it over the first one, matching the size and position of the chart areas.

 

[JRCBoston]

Thank you

I would make 2 charts make the second one transparent (Chart and Plot areas) and put it over the first one, matching the size and position of the chart areas.

Thank you.