Graph with scroll bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Jon and Gord,

thanks a lot for the help

regards
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jon Peltier" escreveu:
 
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.
 
Back
Top