Axis Labels Range

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

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!

After looking at the sample file, my first guess is that the issue is that the Data tab doesn't have all the dates into the future. Hence, when you open the workbook up on a new day, =TODAY()-2 might not exist, and so it doesn't exist in the InterimData tab which is being charted.

At least that was the issue that I had when I opened your workbook. Excel complained about formula issues on the Parameter sheet and that turned out to be the fact that the dates stopped at the 18 January 2019. Once I realised that and fixed it, the graph looks OK. The Named Range mydatesmy, ='YahooStockQuotes8.xlsm'!mydatesmj, comes out as =INDEX(interimdata!$A:$A,MATCH(Parameters!$E$15,interimdata!$A:$A,0)):INDEX(interimdata!$A:$A,MATCH(Parameters!$E$16,interimdata!$A:$A,0))