Seba Robles
Board Regular
- Joined
- May 16, 2018
- Messages
- 71
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello,
I've created a chart for which I need a dynamic range since I will be adding weeks to the right and can't seem to make it work. I am not using tables and prefer to use formulas.
I created a dynamic named range called TEST for the data in A1:Q19 using the following formula: =OFFSET(Sheet1!$A$1,0,0,19,COUNTA(Sheet1!$1:$1))
When I select the data source of the chart and change the data source to the dynamic range (Sheet1!TEST) the chart takes the correct data. But whenever I add a new week the chart is not updated and when I go back to check the data source, it is no longer using the dynamic named range, it goes back to A1:Q19.
Any idea how I can make this work?
Thanks in advance!!
I've created a chart for which I need a dynamic range since I will be adding weeks to the right and can't seem to make it work. I am not using tables and prefer to use formulas.
I created a dynamic named range called TEST for the data in A1:Q19 using the following formula: =OFFSET(Sheet1!$A$1,0,0,19,COUNTA(Sheet1!$1:$1))
When I select the data source of the chart and change the data source to the dynamic range (Sheet1!TEST) the chart takes the correct data. But whenever I add a new week the chart is not updated and when I go back to check the data source, it is no longer using the dynamic named range, it goes back to A1:Q19.
Any idea how I can make this work?
Thanks in advance!!