I have an excel sheet with several worksheets of data. On one worksheet a simple line chart displaing the data from the different worksheets. Data souce for each line graph is =worksheetname!$F$2:$F$90. This works fine but, if I insert a row at F2 of the worksheet, the data source changes to =worksheetname!$F$3:$F$91.
How can I keep the data series locked to $F$2:$F$90?
Example attached.
Bookmarks