Alexander Trifuntov (Ablebits Team) says:April 22, 2020 at 7:17 am
If I got your problem right, it is all about applying a named range when creating a chart. Besides, you want your graph to change when the named range changes, for example, when new rows are added to it.
For this purpose, it is necessary to create a named range, as described above, first of all. Let us suppose we name your range =RATES!$A$37:$A$55 "Rates001". Then you should create a chart and indicate =RATES!$A$37:$A$55 in the Chart Data Range field.
After creating a chart, please click Select Data Source in the menu again, select the data range (Series1) in the Legend Entries window and click Edit. Type =Rates!Rates001 in the Series Values field. Please do not forget to click OK. Now your named range "Rates001" will be a source of data for the graph. I hope I have answered your question. I also recommend reading article on our blog about charts in Excel.Reply