Thread: y axis scale dynamically

is there any way to change the y axis using a data table
info so that on a selected item the scale will change
accordingly.

for example: set up a run chart to fill in using a vlookup
for limits on horizontal plane (x axis) and the averages of the
values plotted as tested, but change the item to a
higher/lower target and limits and have the y axis change
with the new data to scale respectively?

I'm not sure that I understand exactly what you're trying to do but have you checked the Autoscale check box? Unfortunately, I'm using Excel 2007 and it seems to Autoscale with no problems when I simulate what I think you're trying to do.