Sep 04 2018 04:24 AM
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 need to go to the graph, and manually change the 2 "63" numbers above to "64."
How can I have this graph refresh automatically without having to manually change the formula?
Sep 04 2018 04:44 AM
SolutionHi 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/
Sep 11 2018 04:50 AM
I still had to play around with it for a while, but it looks great now. Thanks!
Sep 04 2018 04:44 AM
SolutionHi 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/