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

1: If the size of the data (number of rows and columns) doesn't change, then nothing is required - otherwise a named dynamic range can be used.

2: This will probably take a Sheet Change event to log the data into a data table.

This is as far as I can take it without seeing a sample workbook.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.