Right-click the category labels to change, and click Select Data. How do I change horizontal axis labels in Excel 2020? Under Axis Options, we can choose minimum and maximum scale and scale units measure. If we want to change the axis scale we should: Select the axis that we want to edit by left-clicking on the axis. How do I change the axis values in Excel? 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.Right-click the category labels you want to change, and click Select Data. How do I manually edit the horizontal axis in Excel? Close the window, and the changes will be saved.Under Units, click on the box next to Major and type in the interval number you want.Right-click on the Horizontal Axis and choose Format axis.Open the Excel file with your graph and select it.How do I change the horizontal axis values in Excel? 10 How do I make data labels vertical in Excel?.9 How do I reduce the y axis values in Excel?.8 How do I rotate axis labels in Excel?.7 How do I change axis labels on Excel?.6 How do you change the vertical axis values in Excel 2016?.5 How do you change horizontal to vertical in Excel?.4 How do I change horizontal axis labels in Excel 2020?.3 How do I change the axis values in Excel?.2 How do I manually edit the horizontal axis in Excel?.1 How do I change the horizontal axis values in Excel?.If I delete this chart, then select both region and code, along with activity.Įxcel will build a two-level axis correctly on the first try. There were a lot of steps in that process, but now that the data is structured properly, Excel will plot a multi-level axis correctly from the start. Now I can edit the axis labels again and get the axis to display correctly. Note that I'm holding down the shift key here to insert cells. The solution is to move codes next to region. If I try to use the control key to exclude city, Excel doesn't include both region and codes. However, note that label values need to be in adjacent ranges. For example, I can use select data to include the airport codes as well. You can add more labels to create more than two levels. It's important to know that this checkbox only appears when the axis labels range includes another set of values. If I double-click the axis to open the format task pane, then check Labels under Axis Options, you can see there's a new checkbox for multi level categories axis labels. Now you can see we have a multi level category axis. The goal is to create an outline that reflects what you want to see in the axis labels. Next, I'll remove the extra, unneeded entries from the region column. First, I'll sort by region and then by activity. To straighten out the labels, I need to restructure the data. Well, if I visit Select Data, I can click Edit under Category Axis Labels, and then expand the range to include region.Īs you can see, this adds a level to the axis labels, though it's not very legible at the moment. Holding down the control key, it's a simple matter to plot activity by city in a column or bar chart.īut what if I want to group the cities in by region? We have columns for region, city, airport code, and activity, which represents total take offs and landings. Here we have a list of the busiest US airports. This is easy to do as long as you structure the source data in a particular way. In some cases, you may want to create a chart that shows more than one level of axis labels.
In this video, we'll look at how to build a chart with multi-level axis labels.