To change the scale of other axes in a chart, see Change the scale of the vertical (value) axis in a chart or Change the scale of the depth (series) axis in a chart.
Point where the horizontal axis crosses the vertical axis Under the Horizontal (Category) Axis Labels section, click on Edit. Click on Select Data in the resulting context menu. Right-click on the X axis of the graph you want to change the values of. However, you can specify the following axis options: Launch Microsoft Excel and open the spreadsheet that contains the graph the values of whose X axis you want to change. The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) axis, also known as the y axis, of the chart.
Right-click the value axis labels you want to format.Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 More. To change the format of numbers on the value axis: On the Character Spacing tab, choose the spacing options you want. Its not obvious, but you can type arbitrary labels separated with commas in this field. Click the edit button to access the label range. And select Rotate all text 90 from the Text direction drop down list box. 2 click Alignment menu in the left of Format Axis dialog. Here youll see the horizontal axis labels listed on the right. For Excel 2007/2010: You need to do the below steps to rotate Axis labels: 1 right click on the X Axis label, and select Format Axis from the popup menu list. And the Format Axis pane will appear in the right of window. Step2: right click the Axis label where you want to change label number as percentage, such as: vertical Axis label. On the Font tab, choose the formatting options you want. Instead youll need to open up the Select Data window. Like below: Step1: select range A1:B4, and then go to Insert tab, click Insert Line or Area Chart command under Charts group to create a line chart. 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 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. Select the new x-axis range As a result, we changed x axis values from Years to Stores Figure 5. In the Horizontal (Category) Axis Labels box, click Edit. Select Data on the chart to change axis values Select the Edit button and in the Axis label range select the range in the Store column: Figure 3. 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. How can I edit this graph so that it shows the horizontal axis labels. 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. Right-click the x axis labels area and find the format options - you can specify the upper and lower limits for the axis.