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