Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
scrollbar control of a chart, live or not live
Hello Excel'ers,
This question is not really a programming question, but here goes. I'm baffled. I have a very long list of xy data points. And I can create a chart that shows just a subset of the data, and by using defined names with the =OFFSET function, I can use a spinner or scrollbar to have the chart "move" through the data. All this works fine with no problems, and I've used this technique a lot. However, in some of my files the chart is "LIVE". Which means the chart updates continuously while the spinner or scrollbar is being changed. While other times the chart does not update until I stop scrolling (i.e., release the mouse button). Even on different on worksheets within the same file, the chart on one sheet may update live, while on another sheet it won't. It seems like it might to be some property of the Worksheet object, but I've checked the properties in the VBA properties window, and could find no differences (EnableCalculation property, for example). Does anyone know why this is happening? Thanks, Brian Murphy Austin, Texas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
scrollbar control of a chart, live or not live
Hi Brian,
Whenever I have experience this it has been releated to whether the control was of the forms or control toolbox variety. forms controls update on completion whereas the control toolbox ones give the "live" response. Brian Murphy wrote: Hello Excel'ers, This question is not really a programming question, but here goes. I'm baffled. I have a very long list of xy data points. And I can create a chart that shows just a subset of the data, and by using defined names with the =OFFSET function, I can use a spinner or scrollbar to have the chart "move" through the data. All this works fine with no problems, and I've used this technique a lot. However, in some of my files the chart is "LIVE". Which means the chart updates continuously while the spinner or scrollbar is being changed. While other times the chart does not update until I stop scrolling (i.e., release the mouse button). Even on different on worksheets within the same file, the chart on one sheet may update live, while on another sheet it won't. It seems like it might to be some property of the Worksheet object, but I've checked the properties in the VBA properties window, and could find no differences (EnableCalculation property, for example). Does anyone know why this is happening? Thanks, Brian Murphy Austin, Texas -- Cheers Andy http://www.andypope.info |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
scrollbar control of a chart, live or not live
Hello Andy,
Thanks very much for the tip. I went to one of my sheets that has a scrollbar that does not work "live". It was indeed created with the Forms toolbar. So I created one using the Controls toolbar, and that one does operate "live". So I guess knowing this, I should be able to reliably create "live" scrollbars. Which essentially solves my problem. One thing though, I looked at some my other scrollbars that do work "live", and some of them were definitely created with the Forms toolbar. Is it perhaps possible that my mixed results with Forms scrollbars is due to "inconsistent" behavior on the part controls created with the Forms toolbar? I copied and pasted a working "live" Forms/scrollbar from one sheet to another sheet where there was already a scrollbar that was not "live". I then reassigned the Linked cell, and that scrollbar would no longer work "live", at least on that worksheet. I also copied/pasted a non-live scrollbar to another worksheet, reassigned the cell link, and on that sheet it would work "live". Go figure? It seems to have something to do with the worksheet. But I don't see what it could be. Anyway, if I use the Controls toolbar from now on, maybe I won't have this problem. Cheers, Brian "Andy Pope" wrote in message ... Hi Brian, Whenever I have experience this it has been releated to whether the control was of the forms or control toolbox variety. forms controls update on completion whereas the control toolbox ones give the "live" response. Brian Murphy wrote: Hello Excel'ers, This question is not really a programming question, but here goes. I'm baffled. I have a very long list of xy data points. And I can create a chart that shows just a subset of the data, and by using defined names with the =OFFSET function, I can use a spinner or scrollbar to have the chart "move" through the data. All this works fine with no problems, and I've used this technique a lot. However, in some of my files the chart is "LIVE". Which means the chart updates continuously while the spinner or scrollbar is being changed. While other times the chart does not update until I stop scrolling (i.e., release the mouse button). Even on different on worksheets within the same file, the chart on one sheet may update live, while on another sheet it won't. It seems like it might to be some property of the Worksheet object, but I've checked the properties in the VBA properties window, and could find no differences (EnableCalculation property, for example). Does anyone know why this is happening? Thanks, Brian Murphy Austin, Texas -- Cheers Andy http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
live chart title and a scroll bar | Excel Worksheet Functions | |||
live scrolling | Excel Discussion (Misc queries) | |||
Can a copy of a chart remain "live" | Charts and Charting in Excel | |||
Show value in Data Table but not on live chart | Charts and Charting in Excel | |||
Need Live data in web Excel chart | Excel Programming |