Hello Friends
Please find the attached excel 2010 version file (Chart Primary Y axis scale variation correction.xlsx)
In the Sheet `Sheet1' Cell X17 change the dates 01-Oct-81 or 01-Jan-82 and notice the chart Y Primary Axis scale changing.
If the input is 01-Oct-81 then Primary Y axis scale is 390 to 460 which is much much readable.
But if the input is 01-Jan-82 then Primary Y axis scale is 0 to 450 which is not much readable and why the scale is
not between say 300 to 420 which will make better readbility. So in Cells Y2 and Y3 I plotted the max.
and min Primary Y Axis scales by formula, Is there any way to use macro to input these values in chart ?
thanks in advance
Please find the attached excel 2010 version file (Chart Primary Y axis scale variation correction.xlsx)
In the Sheet `Sheet1' Cell X17 change the dates 01-Oct-81 or 01-Jan-82 and notice the chart Y Primary Axis scale changing.
If the input is 01-Oct-81 then Primary Y axis scale is 390 to 460 which is much much readable.
But if the input is 01-Jan-82 then Primary Y axis scale is 0 to 450 which is not much readable and why the scale is
not between say 300 to 420 which will make better readbility. So in Cells Y2 and Y3 I plotted the max.
and min Primary Y Axis scales by formula, Is there any way to use macro to input these values in chart ?
thanks in advance