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
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
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.
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
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
Yes, I guess that would be my assumption also.
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.
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
perfect! you are all total stars! thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks