Scrolling Data Graph

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

Andy Pope has a scrolling data graph, scroller.xls.
I thought it would be cool to adopt this technique in presenting the day to
day movement of inclinometers.
Typically we have data set of about 150 data each day for some 180 days.
The data is presented as a vertical wiggling curve, day by day or a few
consecutive days in one graph.

I tried with daily data set in individual columns and in one continuous
column.
The method worked but the graph only refreshed when the mouse was released.
The graph did not update smoothly as in scroller.xls

KC
 
Hi,

If you want the chart to update whilst scrolling you need to use an
ActiveX scroller control rather than the Forms scroller.

Cheers
Andy
 
Back
Top