How to Dynamically Change Charts

[PosseJohn]

I have charts that display data over a long period of time.

Sometimes it is necessary to zoom in on a particular area of the graph. I'm trying to create a chart that has scrollbars that will allow scrolling into the area by adjusting the x-axis and y-axis.

Does anyone have a good example / reference to such a project?

Many thanks! Merry Christmas.

[Andy Pope]

It depends on your chart type.

Here is an example of using named ranges to alter start and lenght of data in chart
http://www.andypope.info/charts/Scrolling.htm

You can also search the forum for VBA to alter the min/max values of scales.