In Excel, axis labels are the category names or scale values shown beside a chart’s horizontal or vertical axis. To change category labels, edit the worksheet cells used by the chart or choose Chart Design > Select Data; to add a descriptive axis title, select the chart and choose Chart Design > Add Chart Element > Axis Titles.
Axis labels and axis titles are different
The phrase “axis label” can mean either the individual marks along an axis or a title that explains what the axis measures. In a chart showing monthly sales, the month names along the bottom are category labels, while values such as 0, 500, and 1,000 on the side are scale labels. A title such as “Sales (dollars)” is an axis title, not one of those labels.
This distinction matters because the two kinds of text are controlled in different ways. Category labels usually come from worksheet cells. Scale labels are generated from the chart’s numeric axis settings. Axis titles are separate text elements that you add and type yourself. If the chart’s labels are unclear, first identify which of these three elements you want to change.
Add or remove an axis title
An axis title tells readers what a dimension represents, including units when they are relevant. On Excel for Microsoft 365 for Windows, select the chart, then choose Chart Design > Add Chart Element > Axis Titles. Select Primary Horizontal, Primary Vertical, or another offered axis, depending on the chart. Click the placeholder that appears and type the title. To remove it, select the title and press Delete.
You can also use the green plus button beside a selected chart to turn Axis Titles on or off. The Chart Design route is useful when you need to choose which axis receives a title. For example, a line chart of distance over time could use “Date” on the horizontal axis and “Distance (km)” on the vertical axis. Avoid repeating information already obvious from a nearby chart title, but include units when a number alone could be ambiguous.
For a secondary axis, add its title only after the secondary axis exists. Excel may offer a secondary vertical axis title through the chart element controls. The precise options depend on chart type and whether a series has been assigned to that axis. Excel for Mac has similar chart-element controls, though ribbon layout and some menu wording can differ. Excel for the web supports common chart editing, but its available formatting controls may be more limited than the Windows desktop app.
Change category labels from worksheet data
For a column, bar, or line chart, category labels are commonly linked to a range of cells. The most direct way to change a label is to edit its source cell: the chart updates to match. If the chart uses the wrong range, select it and choose Chart Design > Select Data. In the Select Data Source dialog, find Horizontal (Category) Axis Labels and choose Edit. Select the cells that contain the intended labels, then confirm the dialog.
For example, suppose A1 contains “Month,” A2:A5 contain Jan, Feb, Mar, and Apr, and B1:B5 contain a sales heading and four values. If a chart shows the wrong month names, check whether its category-label range points to A2:A5 rather than to the sales values or an unrelated column. Include the header only when it is appropriate for the chart setup; Excel often recognizes headings when a chart is created from a table of data.
In Select Data, Switch Row/Column changes whether Excel treats rows or columns as data series. It can make a chart look as if its labels are wrong, even though the original cell ranges are valid. If editing the axis-label range alone does not fix the chart, inspect the series orientation and ranges in the same dialog. This is especially useful after selecting non-adjacent columns or rearranging the source data.
Understand numeric axes and chart types
Not every axis uses a list of text labels. A column chart usually places categories at evenly spaced positions and displays numeric values on the value axis. A scatter chart instead uses numeric values on both the horizontal and vertical axes, so Excel positions points according to their numbers. Its horizontal axis is not simply a set of category names; to change point positions, you generally need to change the series’ X values in Select Data.
Chart type also affects which axes exist. A pie chart has no axes, so it cannot display axis labels or axis titles; it uses data labels instead. A horizontal bar chart places categories along the vertical axis and values along the horizontal axis. If a label appears on the “wrong” side, it may be because the chart’s orientation differs from what you expected, not because Excel has mislabeled the data.
Date categories can be handled as a text axis or a date axis. A date axis spaces dates according to elapsed time, while a text axis treats each listed entry as a category in sequence. This difference is noticeable when dates are irregular: a text axis can space each date evenly, but a date axis reflects the gaps between dates. Right-click the horizontal axis, choose Format Axis, and review Axis Type when the option is available for that chart.
Format, rotate, or reduce label clutter
To change label appearance, right-click the axis and choose Format Axis. The Format Axis pane includes controls that vary by axis and chart type. In its Text Options or text formatting controls, you can adjust font, size, color, and text effects. Under the axis’s label settings, you may also find options for label position, label interval, and text direction. A larger font can improve readability, but it may require more chart space.
When category names overlap, try these remedies before shrinking the text until it is hard to read:
- Widen the chart or reduce the number of displayed categories by filtering the source table.
- Use shorter, still-recognizable category names in the source cells.
- Rotate labels or change their text direction in Format Axis.
- Show labels at an interval, such as every second category, when omitting some labels will not make the chart misleading.
- Consider a horizontal bar chart if long category names are difficult to fit below vertical columns.
For axis label intervals, Excel may let you specify how many categories to skip between displayed labels. The data points are not necessarily removed when labels are skipped; the control changes which labels appear. Do not use this as a substitute for explaining an irregular or incomplete data series. If readers need every category to interpret the chart, enlarge or redesign it instead.
Set number formats and axis scale
Numeric axis labels can be formatted without changing the underlying values. In Format Axis, open Number and choose a suitable category, such as Number, Currency, or Percentage, then set options such as decimal places if available. For example, a value axis showing 0.1, 0.2, and 0.3 might be clearer as percentages if the plotted values are proportions. Confirm that the chart’s data and units support that interpretation; formatting a number as a percentage does not convert the underlying value.
In the Axis Options controls, you can often set minimum and maximum bounds, major units, and minor units for a value axis. Automatic bounds are suitable for many charts, but a deliberate scale can help comparisons when the context calls for it. A nonzero minimum on a column chart can exaggerate small differences because the columns are visually compared by length. If you change a bound, make the choice clear and consider whether the chart could mislead readers.
Formatting a date or number directly in the worksheet does not always produce the exact chart-label display you want, because chart axis number formatting has its own controls and may inherit or not inherit source formatting depending on settings and chart context. Check the Format Axis pane if the displayed labels do not match the worksheet. Preserve enough precision to distinguish meaningful values, and avoid adding currency symbols or units to every tick when an axis title can state the unit once.
Show, hide, or reposition an axis
To show or hide an axis, select the chart and choose Chart Design > Add Chart Element > Axes, then choose the relevant primary or secondary axis. The green plus chart button can provide a quicker toggle in desktop Excel. Removing an axis hides its line, tick marks, and labels according to the selected options; it does not delete the source data. A chart without a visible scale may be harder to interpret, so retain context through labels, a clear title, or another appropriate design element.
Axis crossing and label placement can also affect where labels appear. In Format Axis, axis-crossing settings determine where one axis meets another, and label-position settings control where labels sit relative to the plot area. These controls are useful when a chart includes negative values or when labels are crowding plotted data. The names and availability of individual controls depend on whether you selected a category axis or a value axis.
If your goal is to identify individual points rather than describe the scale, use data labels instead. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and select a position. Data labels display information for particular points, such as a column’s value, while axis labels describe categories or the scale. Using both can be helpful, but displaying every point value and every category can make a dense chart difficult to read.
Common axis-label problems
If labels show numbers instead of names, inspect the category-label range in Select Data and confirm it points to the intended text cells. If labels show dates as serial-looking numbers, check the axis number format and whether Excel is treating the axis as a date axis. If a label is missing, check whether its source cell is blank, whether the chart range includes that cell, and whether an interval setting is skipping it.
When a chart displays 1, 2, 3 instead of the expected category names, Excel may be using default point numbers because no category range was assigned or because the selected range was incomplete. Reassign the correct label range rather than typing labels individually onto the chart. If text appears on multiple lines or clips at the edge, give the chart more room, adjust text direction, or revise the source labels. Also check whether a filter or hidden rows are affecting the chart’s displayed data.
A common misconception is that changing the axis title changes the underlying data or axis labels. It does not: a title is explanatory text, while category values come from the source range and numeric scales come from axis settings. Likewise, changing a worksheet cell’s number format does not alter its stored value. Keep the chart’s source, scale, and wording consistent so that the displayed labels accurately describe what is plotted.
Frequently Asked Questions
How do I add labels to an Excel graph axis?
Select the chart and choose Chart Design > Add Chart Element > Axis Titles to add descriptive titles. Category labels normally come from worksheet cells; choose Chart Design > Select Data to set or correct their range.
How do I change the horizontal axis labels in Excel?
Edit the linked worksheet cells, or select the chart and open Chart Design > Select Data. Under Horizontal (Category) Axis Labels, choose Edit and select the cells you want to use.
How can I rotate axis labels in Excel?
Right-click the axis, choose Format Axis, and use the text-direction or text-formatting controls in the pane. The exact controls shown can depend on the chart and the selected axis.
Why are my Excel axis labels showing 1, 2, 3?
The chart may not have a category-label range assigned, or it may point to the wrong cells. Open Select Data and set Horizontal (Category) Axis Labels to the range containing the intended names.
Can I add axis labels to a pie chart?
No. Pie charts do not have axes. Use data labels to show category names or values on or beside slices, or choose a chart type with axes if comparing a scale is important.
Related
- Excel Data Validation Restrictions and Their Limits
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Link a Pivot Chart to a Slicer in ExcelTo link a slicer to an Excel PivotChart, select the PivotTable or PivotChart, choose PivotTable Analyze > Insert…
- Google Sheets Bar Chart Tutorial: Create and CustomizeTo make a bar chart in Google Sheets, select your category labels and numeric values, choose Insert >…
- How to Format Data for a Combo Chart in ExcelTo format data for an Excel combo chart, put category labels in the first column, give each data…
- Excel Histogram Bin Size: How to Set the Right WidthIn Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, open Format Axis, and under Axis…
- P Chart in Excel: Build Control Limits and Read ResultsTo make a p chart in Excel, calculate each subgroup’s fraction nonconforming, find the overall fraction and three-sigma…
- Excel Chart Not Showing X-Axis Values? How to Fix ItIf an Excel chart is not showing x-axis values, select the chart and check that its horizontal axis…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.