Re: dynamic charts and axes scaling
No need to respond, I've answered my own questions and have created a simple program, just a few lines of code that works fine
PeteL
Posts by PeteL
-
-
Re: dynamic charts and axes scaling
So Andy I was happy yesterday and today I want to do more.
There are two problems with the Macro to Automatically set the X & Y Axis scale for a chart based on input data to a worksheet
1) Protecting the worksheet with a password then requires a password before the macro cna be operated
2)The Chart scale does not change with each input of new data but only when the macro is operated. (Ie if the next data point is off range from the previous scale it won't be visible in the plot until the macro is operated)Would a "worksheet event" that is activated by a change in max/min values in cells B1 & B2 solve these issues and if so, what would be the code?
-
Re: dynamic charts and axes scaling
Many thanks for your help Andy
I need to read up a little on workseet events to trigger an action but for now I have recorded the macro and have assigned it to a button.
This achieves the result I requested and it Works just great!!PeteL
-
Re: dynamic charts and axes scaling
This question is related to Axis scaling for scatter charts. I enter variable X& Y values into a work sheet The chart is set up to auto scale the max and minimum axis values (ie scale is based on the input values for any particular set of data) Because of this the minimum and maximum values of the two axes are invariably different but I would like them always to be the same. I can manually set the scales the same for each time I plot data by entering chart options, but I would like to do this automatically. Do I need to write a macro to do this and if so, how would I go about doing it