Forum

Notifications
Clear all

Getting chart to include data from secondary range BUT as a continuation of first range on SAME AXIS

2 Posts
2 Users
0 Reactions
48 Views
(@cfrsh91)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 16/04/2020 6:17 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 16/04/2020 11:21 pm
Share: