Set Xaxis based on Min and Mas of a range

[MitzDriver]

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.

Sounds simple but just can't get it to work.

Thanks in advance. Any help would be greatly helpful.

 

[Wicker]

If you highlight the table involving the aformentioned X axis pertaining to the dbyear and click the Sort button in the "Data tab', the last button before the "My data has headers" checkbox is Options. Click Options. UnderOrientation you will see you have two radio buttons: "Sort from Top to Bottom" and "Sort from Left to Right".
Select that one and sort by the dbyear Row.