Hi,

I was wondering if anyone might know how to make a code that changes the x axis range of a chart to match the x axis range of another chart. I'm thinking along the following line:

1. chart 1 would have a x axis with a particular range (say 1 to 10) which would be preset by the range of the data that is being graphed

2. chart 2 would use a different data set with a different range (say from -5 to 5).

3. Excel would normaly make a chart that best fits the range of data, and the range would be different for both charts.

4. For chart 2 what I would want the display range to be someting like this:

With ActiveChart
.Axes(xlValue).MinimumScale = 'here would be a variable that gets the minimum scale from chart 1
.Axes(xlValue).MinimumScale = 'here would be a variable that gets the maximum scale from chart 1
End With

5. I would want to make it so that if the data range from chart 1 changes, the range in chart 2 would change automatically. The range for chart 1 would be predetermined by excel based on the data.

thanks