How to create a line plot for a refreshing single cell array

Hi,

I am using a query to receive data through an API within Excel that gets refreshed every minute. I have summed and averaged the columns of data into a single cell that updates its value with every refresh. Im trying and failing to do 2 things:

1st: I don't know how to create a line chart that updates itself with the data that is refreshed every 1 minute. I would like to automate the process but struggling to do so
2nd: Save the data from the single cell array into a new table/array or something at every refresh.

I'm quite a novice with excel so any assistance would be greatly appreciated.

Cheers

Brad