Getting chart to include data from secondary range BUT as a continuation of first range on SAME AXIS|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi all

Just wondered if someone can help me out with the following:

I've got a series of data which covers financial balances for the 2019-20 FY in cells C3:AM7, and a series of data which covers balances for 2020-21 FY in cells C9:AM13.

I want to be able to include the 2020-21 FY as a continuation of the data from 2019-20 FY in the chart, but on the same axis, rather than a separate axis overlapping this.

Unfortunately, Excel interprets this as a second axis, which I don't want.

Is there any way around this?

Thanks in advance