+ Reply to Thread
Results 1 to 5 of 5

Graph that updates automatically with time

  1. #1
    Registered User
    Join Date
    09-29-2020
    Location
    Salem, VA
    MS-Off Ver
    16.0.13127.20296
    Posts
    8

    Question 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.
    Last edited by Jack_Vaughn; 09-30-2020 at 11:48 PM.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Graph that updates automatically with time

    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.
    Last edited by mehmetcik; 09-30-2020 at 12:52 PM.
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    09-29-2020
    Location
    Salem, VA
    MS-Off Ver
    16.0.13127.20296
    Posts
    8

    Re: Graph that updates automatically with time

    Okay this is where I am now, thanks for the response!Table.JPG
    Last edited by Jack_Vaughn; 09-30-2020 at 12:39 PM. Reason: Add picture

  4. #4
    Registered User
    Join Date
    09-29-2020
    Location
    Salem, VA
    MS-Off Ver
    16.0.13127.20296
    Posts
    8

    Re: Graph that updates automatically with time

    This is where I am now. I see how all of this is useful, but now I'm confused how I insert the spot price instead of the filter column. I'm sure it's way easier than I think. I am also a but confused. Will the date update daily without me having to interact with it? Attachment 697711

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Graph that updates automatically with time

    You need to enter your prices in Column B.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-09-2020, 04:38 PM
  2. Replies: 1
    Last Post: 09-24-2018, 06:50 PM
  3. Dynamic Graph/ Graph Data updates
    By JPSIMMON in forum Excel General
    Replies: 1
    Last Post: 04-14-2015, 03:11 PM
  4. Replies: 0
    Last Post: 12-11-2013, 12:55 PM
  5. Replies: 2
    Last Post: 08-06-2012, 07:38 AM
  6. How To Create A Chart That Automatically Updates Over Time
    By The_Snook in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-28-2011, 06:34 PM
  7. [SOLVED] Graph formats after updates
    By fcisp in forum Excel General
    Replies: 0
    Last Post: 06-24-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1