Thanks
I enclose the spreadsheet.
On the parameters tab is the graph.
Each data series on the graph refers to a named range. It is this reference to the named range that I want to fix. It seems to change slightly every time I close the spreadsheet which means I need to manually update each named range for each data series in the graph each time I open it.
Any suggestions very much appreciated as this is really bugging me!
Bookmarks