hi,
how do i set up my charts so that the scale is automatically updated, as inputs change? for example, first inputs on the graph might require a scale up to $100,000.
as inputs change, the scale might be needed at say $500,000. i have to manually adjust the scale on each graph.
is there a way that i can set it up so that the scale will adjust dynamically on its own?
i remember finding a method here at mr excel, but can't find the thread that explains it...
any help is much appreciated, it is so tedious to have to adjust the scale on each graph every time we have a change in data....
thx
brenda
how do i set up my charts so that the scale is automatically updated, as inputs change? for example, first inputs on the graph might require a scale up to $100,000.
as inputs change, the scale might be needed at say $500,000. i have to manually adjust the scale on each graph.
is there a way that i can set it up so that the scale will adjust dynamically on its own?
i remember finding a method here at mr excel, but can't find the thread that explains it...
any help is much appreciated, it is so tedious to have to adjust the scale on each graph every time we have a change in data....
thx
brenda