# help - graphs auto updating as new data comes in

1. ## 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

2. ## 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?

3. ## 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. ## 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:
`Please Login or Register  to view this content.`

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

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

Yes, I guess that would be my assumption also.

6. ## 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. ## Re: help - graphs auto updating as new data comes in

Try the following in C39 across and down to J50:

Formula:
`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. ## Re: help - graphs auto updating as new data comes in

perfect! you are all total stars! thank you!

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

#### 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