SOLVED

Adjust graph as I add data, automatically

Copper Contributor

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?

2 Replies
best response confirmed by Brady Gilbert (Copper Contributor)
Solution

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!

1 best response

Accepted Solutions
best response confirmed by Brady Gilbert (Copper Contributor)
Solution

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/

View solution in original post