Click the Format Painter button from the Clipboard group.īoth chart axis labels now have the same font, color, style, and size, this technique can be used in other Excel objects, not just charts.Tips: If you want to quickly format the y-axis to the same font, color, style, and size, follow these steps. Go to the Home tab on the ribbon, then click the default arrow of the Font group and pick another fort, color, size, etc. To change the font formatting like the font, color, style, and size of chart axis labels, select the axis you want to change. Change the format Text or Number of the Axis Labels Just right-click on the Y axis instead of clicking on the X axis. This process works if you want to change the values of the vertical axis. Finally, click the OK button and the values will be replaced with your selection.The Select Data Source dialog box will return and notice that the current values for the X-axis of the chart are replaced with the newly selected values. Then click on the OK to close the Axis Labels dialog box.

Select the cells containing the new value range to use the X-axis.

Excel graph axis label