Scrolling Data Graph

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the graph style I want 4
Graph usage for times of day 0
Macros to convert Data into date format and then plot in graph 7
Use of excel curves as a valid way to estimate unmeasured data 9
plot schedule-type data in graph, date and times as x & y axes 1
Help with "clusters" of plotted data 2
Excel 2007 - Printing graphs with no data or graph lines 1
Line Graph, Time vs Unit, with Data Points 4

Top