View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero
 
Posts: n/a
Default Scrollable x-axis in excel

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.