I have 2 sheets in a workbook.
sheet 1 (named Data) has the data
column A is the X axis
Column B and C have the dual Y axis data
sheet 2 (named graph) but the chart is Chart 1
I update the columns A B & C from and external program using C#
I need the scales to update according to the data setting the min and max for the Y axis(s) plus a small amount outside
the actual min and max (a buffer from the edge of the chart)
as well as the X axis
The major unit can be dynamic based on the data (Y)
X axis is years from 10 to 30
I am comfortable with VBA code