Value Y Axis Scale on a line chart
Posted by Don on November 23, 2000 3:00 PM
I have created a line chart (Chart1 As Object in sheet2) of a workbook.All the values that are being plotted on the chart are coming from Sheet1 in the same workbook. I need to change the Value Y Axis Scale (Maximum and Minimum)from a value in a cell on sheet1 of the workbook. For instance, if the value in cell A1 on sheet1 was 40 and the value in cell A2 on sheet1 was 60 then the minimum Value Y Axis scale would be 40 and the maximum Value Y Axis scale would be 60. I need the axis scale to change every time the values in these two cell change.