Excel "Movie" of Line Graphs

[brianmock]

I have a line graph that I have data on consecutive dates for that I would like to produce a moving through time graph.

Example Daily Sales in the 10 offices... each daily set of data is in one row with date in column A Office 1 in column B... etc.

Could a macro be written to show the changing line graph for a given set of dates within my data?

 

[Nebu]

Hi:

I have given solution for a similar problem in the following thread
http://chandoo.org/forum/threads/clumsy-graph-from-powerpivot-help-to-add-scroll-bar.21142/

Hope this will help you.

 

[Hui]

Posting a sample file would help us help you specifically

 

[brianmock]

I have included a couple of graphs for Jan 6 and Jan 5
Thinking of a Macro to move a single graph through time like a "movie"

 

[Hui]

Like this?

See attached file:

 

[brianmock]

Yes...
I see how the macro waits 1 second in a loop
Cell B2 is set by [myoffset] = i statement

the Chart Series ='Movie Example.xlsm'!Data is reset using a named range

Could a "Slide Bar" be added to drag with the mouse instead of the 1 second delay

 

[Hui]

Yes
Just link it to B2

 

[Hui]

See attached: