You want some kind of dynamic chart. I have some links and general examples
he
http://peltiertech.com/Excel/Charts/Dynamics.html
The example that might help the most is on this page:
http://pubs.logicalexpressions.com/P...cle.asp?ID=246
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"jea123" wrote in message
...
I'm looking for a way to "zoom-in" my x-axis and rather than have all of
the
data from a very large database displayed at once, be able to scroll (as
in a
data aquisition software screen) through it (day-by-day, etc) so as to see
meaningful trends without having to regenerate a new chart when I need to
switch days. I currently am using a 'lines on 2 axis' type of chart.