Right-click the value axis labels you want to format. 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. This article is based on a question from Tony.
Therefore, the plot area needs to be smaller than the chart area to fit the axis labels, and titles outside the chart. Right-click the category axis labels you want to format, and click Font. In the case of Tony's chart in the video, he was having trouble seeing the axis titles and labels because the plot area was too large. 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. 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: Go to the chart and right click its axis labels you will rotate, and select the Format Axis from the context menu. If you are using Microsoft Excel 2013, you can rotate the axis labels with following steps: 1. Rotate axis labels in chart of Excel 2013. 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. Close the dialog, then you can see the axis labels are rotated. 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). This affects all text labels at the same time.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. To make this change, format the axis and go to the Number area, then apply a number format with commas for thousands, and no decimal places.įinally, I'll select the chart, and bump up the font size. Now, on the vertical axis, one change we can make is to use commas for thousands.
Horizontal axis labels excel 2016 update#
Then I'll update the chart to use that label instead. For this, I'll use the TEXT function and the ampersand for concatenation. Next, I'm going to create a new label that concatenates the batch with the date. I just need to use select data again and point to that range. But, since we have some suitable labels in the batch column, we could just use those instead. So that's how you can use completely custom labels. It's not obvious, but you can type arbitrary labels separated with commas in this field. Click the edit button to access the label range. Here you'll see the horizontal axis labels listed on the right. Instead you'll need to open up the Select Data window. You won't find controls for overwriting text labels in the Format Task pane. Let's say we want to label these batches using the letters A though F. The dates still appear, but now they're plotted at equal intervals. Just record creating a combo chart with XL 2016 and apply the respective changes to your VBA. This should be an easy task if you are using VBA.
Horizontal axis labels excel 2016 full#
This immediately gets rid of the gaps, since Excel is no longer plotting these dates across the full date range. Excel 2013 and later have a different way to show combination charts (like column and line) and you may need to re-define the X axis values.
So, the first thing I'll do is set the axis type to text. This happens because Excel automatically sets the axis type to date, which makes sense since we have dates in the data. The first thing you probably notice is that there are some gaps in the columns.
Let me insert a standard column chart, and let's run through some options in adjusting the labels that appear in the horizontal category axis. We have a date, quantity, and a field to indicate batch number. Here we have a simple set of generic shipping data. In this video, we'll look at some examples of formatting axis labels.