+ Reply to Thread
Results 1 to 2 of 2

creating line chart based on one cell that auto updates over time

  1. #1
    Registered User
    Join Date
    07-07-2019
    Location
    london
    MS-Off Ver
    2013
    Posts
    6

    creating line chart based on one cell that auto updates over time

    Hi,

    your help with be most appreciated.

    i was wondering if this was possible in excel.

    i have a spreadsheet containing detail of weather. example is attached.

    this spreadsheet would be linked to some software which collects the data of weather in degrees.

    the spreadsheet updates the data and overwrites the cells every 1 hour.

    i would like to create a line chart that records the data in cell c3,c5,c7 , etc - basically all the changes in degrees over time.

    unfortunately each update, every hour, rewrites the existing data.

    is there any way i can plot the line chart - to say show for example london 09.00 = .08 degrees, 10.00 = .12 through to 14.00 = .22

    many thanks to anyone that can help with this

    steve r
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,932

    Re: creating line chart based on one cell that auto updates over time

    After a few days, I will venture to respond
    the spreadsheet updates the data and overwrites the cells every 1 hour.
    Your sample sheet does not seem to show how this update occurs. My first thought for solving this problem would be to look at the procedure/routine/utility that is updating the spreadsheet and see if there is any way to change/edit/modify the updating procedure so that it does not overwrite. Something that appends the data would be easier to work with. I don't see any indication of how that update is happening, so I cannot make any specific suggestions.

    If the update procedure cannot be changed to something that appends rather than overwrites, then you will need a new procedure/routine that will copy and append the data to another part of the spreadsheet.

    I expect that the data arrangement as is will not be very conducive for creating charts or other summaries. So much depends on what you are going to need to do with this, but I expect that you will be better served in the long run to make the procedure arrange the data in a good database format. That will make it easier to make pivot charts/filters and perform other database type operations on it later.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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