If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|