I have some data which will be graphed using a macro. The data is in a dynamic named range. The data is pulled from another database and then dumped into the spreadsheet. A macro then builds the graph.
How do I change the scale on the graph to reflect the high and low values of the new data? For instance, if the new data contains a high number of 1.899 and a low number of 1.755, then the Y-axis scale of the graph will change to reflect the new high and low numbers. This scale will need to change every time new data is pulled in to match the new data.
Is there a way to achieve this?
Thanks.
How do I change the scale on the graph to reflect the high and low values of the new data? For instance, if the new data contains a high number of 1.899 and a low number of 1.755, then the Y-axis scale of the graph will change to reflect the new high and low numbers. This scale will need to change every time new data is pulled in to match the new data.
Is there a way to achieve this?
Thanks.