Hide chart (scatter) by one or more intervals to the left when new data is entered.

[diivus]

Hi guys i'm new here. Saw several of your post, valuable to me eventually..
I'm working a graph in excel so that it updates automatically when new data are entered. So far so good.
However the chart box still displays the very first value I entered as well as the last value(lately entered). I imagine if I have say 5 years daily entry to make, the values will be closer and difficult to read.
Is there any solution like to make 2 or more old entries hide to the left when new data are entered and access any old entries whenever reference is needed?

Please see attached file as example.

Thanks and waiting for your post.

[dilipandey]

HI diivus,

Welcome to the forum.

Enhanced the defined name used as a data source in charts, now charts will always show bottom 31 results

Test on Update Graph.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[diivus]

Thks Dilip, thks a lot for your quick reply. That is what is need :-)
But can you tel me how to "Enhance the defined name used as a data source in charts"? please help me yaar

Thnks again

[diivus]

Dilip can you also tell how to access old entries...

Thnks

[diivus]

Re: Hide chart (scatter) by one or more intervals to the left when new data is entered.

Thks Dilip, thks a lot for your quick reply. That is what is need :-)
But can you tel me how to "Enhance the defined name used as a data source in charts"? please help me yaar

Thnks again

[dilipandey]

Hi diivus,

Press Ctrl + F3 to see the defined names and the formula used there.. try exploring those options and functions used there

Regards,
DILIPandey
<click on below * if this helps>