Forum Discussion

Copper Contributor

Sep 04, 2018

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...

SergeiBaklan
Sep 04, 2018
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/

Diamond Contributor

Sep 04, 2018

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/

Brady Gilbert
Copper Contributor
Sep 11, 2018
I still had to play around with it for a while, but it looks great now. Thanks!