| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help for chart scroller
Hello again,
i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help for chart scroller
If it's a scroller from the Forms toolbar, right click on it and select
Format Control. If it's a scroller from the Controls Toolbox, click the Design Mode button (pencil, ruler, and triangle on the icon) on the Visual Basic toolbar (View menu Toolbars if you don't see the toolbar) or on the Controls Toolbox. Then right click on the scroller and select Properties. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hello again, i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help for chart scroller
sorry, pls disregard this post...got it already upon clicking design mode
-- ***** birds of the same feather flock together.. "driller" wrote: Hello again, i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help for chart scroller
Hi Sir Jon,
thanks...i forgot to ask something else <most important part... will it be possible that the LINE CHART's Y-axis (the Max-Min) value toggle also as i scroll the X-axis scroller.... the reason is to allow me to zoom-in more better while looking at the line chart and enabling me to position the plotted line somewhere (not necessarily or exactly in the middle ) inside the chart....tHE the chart will be composed of 4 different line series.... i like to have it video-clip while scrolling for presentation purpose.... thanks for your time and knowledge shared to us... -- ***** birds of the same feather flock together.. "Jon Peltier" wrote: If it's a scroller from the Forms toolbar, right click on it and select Format Control. If it's a scroller from the Controls Toolbox, click the Design Mode button (pencil, ruler, and triangle on the icon) on the Visual Basic toolbar (View menu Toolbars if you don't see the toolbar) or on the Controls Toolbox. Then right click on the scroller and select Properties. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hello again, i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help for chart scroller
I guess it depends on how you've set up the data, and the formulas, and how
the chart's axes rescale themselves. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hi Sir Jon, thanks...i forgot to ask something else <most important part... will it be possible that the LINE CHART's Y-axis (the Max-Min) value toggle also as i scroll the X-axis scroller.... the reason is to allow me to zoom-in more better while looking at the line chart and enabling me to position the plotted line somewhere (not necessarily or exactly in the middle ) inside the chart....tHE the chart will be composed of 4 different line series.... i like to have it video-clip while scrolling for presentation purpose.... thanks for your time and knowledge shared to us... -- ***** birds of the same feather flock together.. "Jon Peltier" wrote: If it's a scroller from the Forms toolbar, right click on it and select Format Control. If it's a scroller from the Controls Toolbox, click the Design Mode button (pencil, ruler, and triangle on the icon) on the Visual Basic toolbar (View menu Toolbars if you don't see the toolbar) or on the Controls Toolbox. Then right click on the scroller and select Properties. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hello again, i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help for chart scroller
Thanks again Mr. Jon,
Sir, is there any available sample worksheet which i can download from our friendly linksites, it may shorte my search for "formulated set-up of scroller(s) of X AND Y axes...for optimum chart presentation and work control... best regards... -- ***** birds of the same feather flock together.. "Jon Peltier" wrote: I guess it depends on how you've set up the data, and the formulas, and how the chart's axes rescale themselves. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hi Sir Jon, thanks...i forgot to ask something else <most important part... will it be possible that the LINE CHART's Y-axis (the Max-Min) value toggle also as i scroll the X-axis scroller.... the reason is to allow me to zoom-in more better while looking at the line chart and enabling me to position the plotted line somewhere (not necessarily or exactly in the middle ) inside the chart....tHE the chart will be composed of 4 different line series.... i like to have it video-clip while scrolling for presentation purpose.... thanks for your time and knowledge shared to us... -- ***** birds of the same feather flock together.. "Jon Peltier" wrote: If it's a scroller from the Forms toolbar, right click on it and select Format Control. If it's a scroller from the Controls Toolbox, click the Design Mode button (pencil, ruler, and triangle on the icon) on the Visual Basic toolbar (View menu Toolbars if you don't see the toolbar) or on the Controls Toolbox. Then right click on the scroller and select Properties. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "driller" wrote in message ... Hello again, i had downloaded a very smart file from AndyPope "Scroller.xls" on a zip file.... it helps me to build a 30km long highway chart in an instant, yet i just want to consult one thing.. i need to revise the max and min value for the scroller. but i can't enter the form control setting for this scroller.. i use excel2003SP2... please help me finish this file...asap... regards -- ***** birds of the same feather flock together.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scroller tool | Charts and Charting in Excel | |||
| Mouse Scroller | Excel Discussion (Misc queries) | |||
| Scroller Incrementation | Charts and Charting in Excel | |||
| Scroller Incrementation | Excel Programming | |||
| Scroller chart questions | Charts and Charting in Excel | |||
Linear Mode
