Thread: Scrollable x-axis in excel

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.

You want some kind of dynamic chart. I have some links and general examples
here:

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" <jea123@discussions.microsoft.com> wrote in message
news:565141AF-D205-48A7-85F5-5C689A6B33D1@microsoft.com...
> 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.

Hi jea123,

For an old macro (with, I think an interesting approach) see 'Zoom Charts'
at http://edferrero.m6.net/charting.aspx

Ed Ferrero
http://edferrero.m6.net/

> 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.