I have a load of charts on a master spreadsheet and they all use dynamic ranges to update as more data is collected.
The idea is for each unit tested, a new worksheet is created by copying the master (which is hidden). When the sheet is copied, all of the named ranges in the master automatically copy also and the charts on the new sheet refer to the correct named range in that sheet.
Problem is, one doesn't work! It is the x-coordinates and they still refer to the original range in the master spreadsheet. The y's work though.
the formula for the named range is:
=IF(ISERROR(OFFSET(Master!$F$19,0,0,1,COUNT(Master!$19:$19))),0,OFFSET(Master!$F$19,0,0,1,COUNT(Master!$19:$19)))
This named range is duplicated ok, but the chart doesn't for some reason.
Any ideas?
The idea is for each unit tested, a new worksheet is created by copying the master (which is hidden). When the sheet is copied, all of the named ranges in the master automatically copy also and the charts on the new sheet refer to the correct named range in that sheet.
Problem is, one doesn't work! It is the x-coordinates and they still refer to the original range in the master spreadsheet. The y's work though.
the formula for the named range is:
=IF(ISERROR(OFFSET(Master!$F$19,0,0,1,COUNT(Master!$19:$19))),0,OFFSET(Master!$F$19,0,0,1,COUNT(Master!$19:$19)))
This named range is duplicated ok, but the chart doesn't for some reason.
Any ideas?