To change the format of numbers on the value axis:
#EXCEL MULTIPLE AXIS LABELS HOW TO#
I get asked how to do this regularly, so figured it warrants a quick 'how to' post. Change the format of text and numbers in labels. In Excel, there is a quick trick to fix this. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4. In the Axis label range box, enter the labels you want to use, separated by commas. In the Horizontal (Category) Axis Labels box, click Edit. On the Character Spacing tab, choose the spacing options you want. Right-click the category labels you want to change, and click Select Data. On the Font tab, choose the formatting options you want. Right-click the category axis labels you want to format, and click Font. To change the format of text in category axis labels: Change the format of text and numbers in labels Click on the Axis Title you want to Change (Horizontal or Vertical Axis) 4. In the Axis label range box, enter the labels you want to use, separated by commas.įor example, type Quarter 1 ,Quarter 2,Quarter 3,Quarter 4. Double Click on your Axis Select Charts & Axis Titles.
Right-click the category labels you want to change, and click Select Data. To keep the text in the source data on the worksheet the way it is, and just create custom labels, you can enter new label text that's independent of the worksheet data: Type the text you want in each cell, and press Enter.Īs you change the text in the cells, the labels in the chart are updated. Your chart uses text from its source data for these axis labels.ĭon't confuse the horizontal axis labels-Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them-East Asia Sales 2009 and East Asia Sales 2010.Ĭlick each cell in the worksheet that contains the label text you want to change. In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 More.