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
Hi Chris,
Welcome to our forum. If you want the data treated as one series i.e. a continuation of the axis then you must store the data in one row/column in the worksheet. It can't use non-contiguous cell ranges and treat them as contiguous.
Mynda