Excel graphs-Use data in a range for an axis scale?

[Bucky]

I update a set of 200 graphs monthly where the bottom axis is each o
the most recent 24 months (ie Dec '03, Jan '04, etc).

In order to update the , I need to manually right-click the axis
select 'Scale', then enter a 5 digit number that correspond to the dat
for the minimum and maximum for each of the 200 graphs. Needless t
say this is very time-consuming.

I was wondering if there was a way to link the minimum and maximu
scale value to a data range somewhere on the spreadsheet so I ca
change them all at once.

Thank you for your time

 

[Frank Kabel]

Hi
have a look at
http://www.tushar-mehta.com/excel/software/autochart/index.html

for an add-in which will link the axis scales to a cell

 

[Bucky]

Holy smokes! That's perfect. Thank you so much, Frank

 

[Frank Kabel]

Hi
Though thanks are always welcome I think in this case the thanks should
go to Tushar Mehta