Originally Posted by
RobPot
Thanks but I already have the charts set up.
Could the problem be too many Offsets?
1) From the initial data sheet (called 'Data Sheet') I use the following formula to bring the data into rows:
=IF(OFFSET('Data Set'!$B$2,COLUMN()-COLUMN($B$2),0)="","",OFFSET('Data Set'!$B$2,COLUMN()-COLUMN($B$2),0))
-This works fine.
2) On the individual crime type sheets I base a chart on a Named Range 'ChartLength' which allows the user to select how many periods to show, and a dynamic range: 'Total_Crime_Tactical_Period' (so, for example on the worksheet entitled 'Total Crime':
=OFFSET('Total Crime'!$B$2,0,COUNTA('Total Crime'!$2:$2)-1,1,-MIN(ChartLength,COUNTA('Total Crime'!$2:$2)-1))
I then have a series of offsets to rows below to chart the various series.
the problem seems to be that since I've added the =IF(OFFSET="","", line the chart no longer finds the 'Total_Crime_Tactical_Period' range.
Anyone able to offer any light?
Thanks
Robert
Bookmarks