To change the format of numbers on the value axis: On the Character Spacing tab, choose the spacing options you want. 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: 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. Inside the Format Axis options, change Automatically select based on data to Text axis. At the top of the Excel window, click on the Layout tab, then click the drop-down. In the Horizontal (Category) Axis Labels box, click Edit. In order to display dates and times correctly, right-click the horizontal axis and choose Format Axis. Text-based Axis Click on the Excel file that consist your graph and click anywhere on the graph to select it. Change the format of text and numbers in labels Right-click the category labels you want to change, and click Select Data. You can select new data to replace the existing X values. Right-click in the axis and choose Format Axis. You can easily change the X axis values by editing your data 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. To change the format of the label on the Excel 2016 chart axis, do the following: 1. In the Horizontal (Category) Axis Labels box, click Edit. 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). From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis.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.Make sure that the chart is still selected.In the dialog box under Horizontal (Category) Axis Labels, click Edit.From the Design tab, Data group, select Select Data.From the Chart Tools, Layout tab, Current Selection group, select the Horizontal (Category) Axis.Make sure that you select the headings as well as the data before you create your chart. Microsoft Excel 2010 is a very helpful tool for organizing and displaying data.
HORIZONTAL AXIS LABELS EXCEL 2016 SERIES
In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK.Īrrange your data so that headings are directly above and to the left of the data to be charted.In the dialog box under Legend Entry Series, select the first series and click Edit.In the Axis label range enter the cell references for the x-axis or use the mouse to select the range. In the dialog box under Horizontal (Category) Axis Labels, click Edit. There should be no blank rows or columns. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. Arrange your data so that headings are directly above and to the left of the data to be charted.In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit.Make sure that you select the headings as well as the data before you create your chart.
HORIZONTAL AXIS LABELS EXCEL 2016 HOW TO
264How can I make an Excel chart refer to column or row headings?Īrrange your data so that headings are directly above and to the left of the data to be charted. This tutorial will explain how to add Axis Labels on the X & Y Axis in Excel and Google Sheets How to Add Axis Labels (X&Y) in Excel Graphs and charts in Excel are a great way to visualize a.