Graph that updates automatically with time

I don't have anything to show here because I have no idea how to do something like this. I want to take the spot price of silver and put it among a line chart to show the changing price. I have a website to pull data from. I know how to import dat from the web by the way, that's not the problem. Every tutorial I can find revolves around using the historical prices. These charts do not update. Essentially, I want to have a graph that starts with one data point, and every day another is added, with a line connecting the two points. In other words, I want it to look like a stock chart that updates automatically. I understand by doing this I might need two columns; one with the date, and one with the silver spot price. I want the cells at the bottom of these columns to automatically fill themselves in. If I was to use this Excel sheet for a year and three days, I would want 368 rows in each of these two columns. Lastly, I want to be able to program the graph itself to be capable of displaying "Last week", "Last Month", and "Last Year". I am fine with using historical data for this, but I don't want to rely on updating it every single day afterwards.

Hi Jack

Try this as a test

Type "Date" in A1
Type "Filter" in B1

Type 01/09/20 in A2
Type =Row() in B2

Select A2 to B2 and Drag down.

*****************************************

So. Now you have some data

Select A1 ( Or any other cell in your data.

Select the Home Tab, Select Insert and then "Table".

Your Data is now in a table format.

This is very useful you will see why in a minute.

*****************************************

So. Click on any cell in your table.

Select the Home Tab, Select Insert and then "Recommended Charts".

Choose the chart that you like .

Your Data is now in a Chart.

*****************************************
Finally select the first empty row below your table

Type a date in Column A.

The =Row() formula is inserted automatically

The Table is expanded automatically

The Chart is expanded automatically.

*****************************************

There you go. In your scenario column B will be your price
But your table and chart will update automatically.

The only additional thing that you could do to speed things up is to install a small macro to enter the date for you.


*****************************************

Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

Now if you click on the empty cell below your data. the date is inserted for you.
*****************************************

Oops

This Macro is better:=

Please Login or Register  to view this content.

Okay this is where I am now, thanks for the response!Table.JPG

You need to enter your prices in Column B.