Forum Discussion
Solved
Adjust graph as I add data, automatically
I have an Excel spreadsheet that I update each day. On the second page, I have a graph with the following formula: =Data!$A$1:$A$63,Data!$R$1:$R$63 Tomorrow, when I add data to row 64, I will ne...
Hi Brady,
You may use dynamic chart ranges, more about that is, for example, here https://www.techrepublic.com/blog/microsoft-office/two-ways-to-build-dynamic-charts-in-excel/
Hi Brady,
You may use dynamic chart ranges, more about that is, for example, here https://www.techrepublic.com/blog/microsoft-office/two-ways-to-build-dynamic-charts-in-excel/
I still had to play around with it for a while, but it looks great now. Thanks!