Tired myself but not that good a vba.
Would like to set the minimum and maximum value of the xaxis with the min & max value in a range name.
i.e.
Chart 4 Xaxis minimum value = the minimum value of a range named dbyear.
Chart 4 Xaxis maximum value = the maximum value of range named dbyear...