Overlay Line Chart onto a Stacked Bar Chart

Hi All,

Been struggling with this one for a while now, so I hope someone can help!

I want to overlay a line chart on top of a stacked bar chart. Instead of explaining it all I've attached what I've been working on. The first tab are the two charts and then second tab is how I would like it to look.

As a bit of background - one chart is my investment portfolio asset allocation and the other is performance of MSCI World Local

Thank you in advance!

Kind regards
Samuel

Hello Samuel
Maybe as Chart1 in the attached reply.

Hope this helps.
DBY

DBY - Thank you so much - This is perfectly what I was after!

My only question, if you don't mind, is how I can replicate this myself? What roughly were your steps?

I've been playing with "Change Series Chart Type" and "Format Data Series > Series Option > Secondary Axis" but can't quite get it right...

Thank you again,
Samuel

Actaully just figured it out - I needed to change the options on the axes.

Thank you both and have a good day!