Jon,
Thanks, particularly for the slider technique which I would like to adopt
for one of my graphs. The challenge I have is this (Excel2007):
I have got a daily-expanding (dynamic) graph using named ranges.
How do I set up my slider so that it too knows what the current maximum
value is?
Since I can't use a cell reference for the Maximum this seems to be not very
straight forward.
I thought of setting a "very large" maximum and then using some proportional
or percentage method to find the nearest point in my range. But that is not
very good if the actual number of entries is rather small - say less than 20%
of the set maximum.
"Jon Peltier" wrote:
Here's an even more extensive example:
http://pubs.logicalexpressions.com/P...cle.asp?ID=246
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Go to Stephen Bullen's site and download FunChrt7.zip
http://www.oaltd.co.uk/Excel/Default.htm
Gord Dibben MS Excel MVP
On Wed, 14 Nov 2007 06:24:03 -0800, Marcelo
wrote:
Hello, guys, I'm back
I lokking for a sample of a graph with scroll bar to change the data on
the
graph box.
best regards