Auto Scroll the Graph in Excel

[sandarbhasthana]

Hi everyone,

I'm trying to make a graph on the base of data which I get from a external source database and what I need to know that is there a possibility that the graph auto scrolls to the current value and work like a real time graph and if not then can it be achieved through VB Code.

Any help would be highly appreciated.

Thanks!

 

[bobsan42]

To change the graph scope you have two possibilities:
1. Change the data range
2. Change the min and max axis values.
Both can be done by vba code on a timer basis - each minute, each hour, etc.
First can also be done w/o code. To do it you have to set the data to contain only values from the period you need. For this you must not refer directly to the full data range, but to a secondary range which will only contain some extract from the full data - this can be done by some conditional formulas.

 

[sandarbhasthana]

Hi,

Thanks for the reply. I'll surely try it and let you know.
Will it look like this:

https://tenor.com/0cPz.gif

the one on the bottom right. Because that's what I need.

Thanks!

 

[bobsan42]

It could. I guess it depends on the data refresh rate. But w/o a live feed i can't test it.

 

[sandarbhasthana]

Ok fine I'll do that and check..
Thanks a lot!