Cantonalives
Member
Hi All,
I have used offsets to chart data. This data uses N/A# where blank or zero so it does not plot.
Data runs Jan to Dec. The above N/A# process works well when the N/A# comes late in the year. But does not work if the N/A# is at the start of range OR if there are gaps in the data - for instance, blanks in Jan, numbers mid year and then blanks (N/A#) at the end of the year.
Sample of the offset I am using.
=offset('Test1'!$b$9,0='test1'!$b$9:$an$9,0,1,count('test1'!$b$9:$b$9:$an$9))
Any help is much appreciated...
Thanks - CL.
I have used offsets to chart data. This data uses N/A# where blank or zero so it does not plot.
Data runs Jan to Dec. The above N/A# process works well when the N/A# comes late in the year. But does not work if the N/A# is at the start of range OR if there are gaps in the data - for instance, blanks in Jan, numbers mid year and then blanks (N/A#) at the end of the year.
Sample of the offset I am using.
=offset('Test1'!$b$9,0='test1'!$b$9:$an$9,0,1,count('test1'!$b$9:$b$9:$an$9))
Any help is much appreciated...
Thanks - CL.