+ Reply to Thread
Results 1 to 8 of 8

help - graphs auto updating as new data comes in

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    Excel from MS Office 2013
    Posts
    14

    Question help - graphs auto updating as new data comes in

    Hi,

    I have some graphs that need to auto change as each new weeks data is input. Ive attached a template to show this. its the midpoint that I need to change as a new weeks data comes in

    Can anyone help?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help - graphs auto updating as new data comes in

    Hi

    What makes you believe the midpoint isn't being updated? It changes when I change the values in the relevant cells.
    Have you checked that Calculation is set to automatic and not manual?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: help - graphs auto updating as new data comes in

    Richard

    I've just looked at the OP's file and in cell C39 for example, in the Mid Point table, the hard coded formula is adding C$23 and C$27. If you add a sixth week figure to the Running table this isn't calculated as it now needs to reference C28. I wondering if that reference needs to be dynamic? Perhaps worboysn could clarify.

    DBY

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help - graphs auto updating as new data comes in

    Hi,

    In that case if it's the midpoint you wan in C39 should be
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and for simplicity I'd make C40 copied down =C39

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: help - graphs auto updating as new data comes in

    Yes, I guess that would be my assumption also.

  6. #6
    Registered User
    Join Date
    05-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    Excel from MS Office 2013
    Posts
    14

    Re: help - graphs auto updating as new data comes in

    Thanks guys - its slightly different to the mid point (or median) which is causing me the difficulty - its literally the middle of the 1st and last weeks data that I'm after - so the 1st week will always remain constant but the last (or latest) weeks data will form the other side of the range for the mid point to be calculated on.

  7. #7
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: help - graphs auto updating as new data comes in

    Try the following in C39 across and down to J50:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This sums the first week and the last week's entry and divides by 2. This assumes the weeks are entered in sequence without gaps.

    DBY

  8. #8
    Registered User
    Join Date
    05-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    Excel from MS Office 2013
    Posts
    14

    Re: help - graphs auto updating as new data comes in

    perfect! you are all total stars! thank you!

+ 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. Auto updating graphs as new data becomes available
    By retrospikz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-26-2015, 07:22 AM
  2. Replies: 1
    Last Post: 10-24-2014, 12:20 AM
  3. Auto Updating Graphs with pre populated columns
    By controlfreak in forum Excel General
    Replies: 0
    Last Post: 02-28-2014, 10:44 AM
  4. Auto-updating graphs + percentage of pool formula.
    By cd254 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2013, 06:15 AM
  5. Help with "Define Name" & auto-updating graphs
    By chrshrrsn in forum Excel General
    Replies: 5
    Last Post: 04-08-2011, 08:24 AM
  6. Large file auto-updating and graphs sourcing pivot tabes
    By Sam_Gregson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2009, 07:25 AM
  7. Excel graphs not updating when source data is changed
    By James Carlson in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-23-2006, 01:50 PM

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