Scrolling Data Graph
 

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

Scrolling Data Graph
 

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

KC wrote:
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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Scrolling Data Graph
 

Thank you for the advice.
I never thought of that.
I will try.

KC

"Andy Pope" wrote in message
...
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

KC wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info