Copy Axis Specs To
Click the Copy axis specs to button on any of the Axis tabs (i.e., General, Title, Scaling, Major Units, Minor Units, Scale Values, or Custom Units) of the Graph Options dialog box to display the Copy axis specs to dialog box. Use these options to transfer properties (e.g., formatting, labeling, scaling) from one graph axis to another. Note that before clicking the Copy axis specs to button, the source axis whose properties you want to copy should be selected in the Axis drop-down box next to the Copy axis specs to button.
The Copy axis specs to dialog box contains relevant options in the form of check boxes from each of the seven axis-related tabs in seven boxes bearing the same names. Any combination of options from all of the boxes can be selected for copying to another axis. The destination axis or axes to which the properties are to be copied should be selected under Copy to. After clicking the OK button and closing the dialog box, the designated properties will be copied and displayed on the selected axis/axes.