i have created a macro that produces one main graph. after producing the main graph, the macro produces about 15 graphs that zoom on particular areas of the main graph. the idea is to change the scale of the x-axis (which is time) between certain times to focus on this area. at this point i need the y-axis to be able to scale automatically based on the portion of the graph that is showing. if MinimumScaleIsAuto and MaximumScaleIsAuto is set to True for the y-axis, the y-axis is rescaled in the zoomed portion of the graph based on the entire graph. does anyone know how to fix this? thanks for any help in advance