How to Hide the Number Axis in an Excel Pareto Chart

Charts & pivot tables · Updated November 20, 2026

To hide the numbers on an Excel Pareto chart without removing its bars or cumulative-percentage line, select the number axis, open Format Axis, then set Labels > Label Position to None. This hides the axis labels while keeping the chart’s data and scaling intact. The steps below are for Excel for Microsoft 365 on Windows; they also explain how to handle the percentage axis and what to do if the chart layout changes.

What You’ll Need

  • An Excel workbook containing a Pareto chart. In Microsoft 365, you can create one by selecting a category-and-value data range and choosing Insert > Insert Statistic Chart > Pareto.
  • Access to the chart’s formatting controls. The desktop version of Excel for Microsoft 365 provides the most complete controls; if you are using Excel for the web, some axis-formatting options may be limited.
  • A clear idea of which numbers you want to hide. A Pareto chart may show category names along the bottom, counts on a vertical axis, and cumulative percentages on another vertical axis. These are separate chart elements.

Step-by-Step

  1. Select the Pareto chart. Click once inside the chart area so the chart is selected and the contextual Chart Design and Format tabs appear on the ribbon. If you only see cell-selection borders, click the chart again, away from a worksheet cell. Selecting the chart first makes it easier to target the correct axis and confirms that you are editing the chart rather than the source data.
  2. Identify the number axis you want to hide. Look at the chart before changing anything. The left vertical axis commonly displays counts or other values for the bars. A right vertical axis, if shown, commonly displays cumulative percentage for the line. The horizontal axis along the bottom normally lists categories; it is not the count axis even though its labels may include numbers. Decide whether you want to hide the left-side values, the right-side percentages, or both.
  3. Select the axis labels, not a bar or gridline. Move the pointer over one of the numbers on the target vertical axis and click. The axis should become selected as a group, usually with selection handles or a visible highlight. If you click a particular number and only that one label is selected, click again on the axis line or in the space between labels to select the complete axis. Avoid clicking a bar, the cumulative line, or a horizontal gridline; those are different chart elements.
  4. Open the axis formatting pane. Right-click the selected axis and choose Format Axis. The Format Axis pane opens at the side of the Excel window. You can also select the axis and use Format > Current Selection > Format Selection on the ribbon if right-clicking is awkward. Check the pane heading to make sure it says the axis you intended to format. If it names a data series or chart area, close the pane and select the axis again.
  5. Turn off the axis labels. In the Format Axis pane, open Axis Options, then expand Labels. Open Label Position and choose None. The numeric labels should disappear immediately. This setting hides the printed numbers; it does not delete the data, change the bar heights, or recalculate the cumulative percentage. The chart can still use the axis scale to draw its values correctly.
  6. Decide whether to keep the axis line and tick marks. Label Position set to None removes the numbers but may leave the vertical axis line or tick marks. If you want a cleaner appearance, use the Format Axis pane’s Fill & Line options to set the axis line to No line, if that option is available for the selected axis. Axis line and tick-mark controls are separate from label position, so adjust them only if you also want those visual marks gone. Keeping the line can help readers judge the chart’s scale even when its numbers are hidden.
  7. Repeat for the other vertical axis only if needed. If the chart has a right-side percentage scale and you want those labels hidden too, click one of the percentage labels on the right and repeat the Format Axis steps. Do not assume the first change affects both sides: primary and secondary axes are independent. Leave the percentage axis visible if the cumulative line needs that scale to be understandable.
  8. Review the chart at its final size. Click outside the chart to close the formatting pane and inspect the result. Confirm that the bars, categories, and cumulative line remain visible and that you hid only the intended labels. If the chart will be printed, pasted into a report, or viewed at a smaller size, check it at that size as well. A chart that looks clear on a large worksheet may need a visible axis title, data labels, or a note to explain what the values represent.

Common Mistakes

Deleting the wrong chart element. Pressing Delete after selecting a number can remove an individual label, a data point, or an entire axis, depending on what Excel has selected. That can lead to an inconsistent chart or remove more than you intended. Use Label Position > None when your goal is to hide every number on one axis while preserving the chart structure. If you do delete something accidentally, use Ctrl+Z on Windows or Command+Z on Mac promptly, then reselect the axis.

Hiding the category labels instead of the value axis. The labels along the bottom identify causes or categories and are not the same as the numeric scale. Hiding them can make it impossible to tell which bar represents which category. Click a number beside the bars to target the vertical value axis, not a label beneath a bar.

Removing gridlines when only labels needed hiding. Gridlines and axis labels are separate elements. Deleting the gridlines may make bar heights harder to compare, while leaving labels visible does not meet the original goal. Change the axis label position first. Then decide separately whether the gridlines help the reader.

Removing the entire axis and losing useful context. Deleting an axis can remove its line, labels, and other axis formatting together. Although the bars may remain, readers may not know whether they show counts, dollars, or another unit. Hiding labels is usually the safer choice. If you intentionally remove the complete axis, add a clear axis title, data labels, or explanatory text where appropriate.

Expecting hidden labels to change the chart’s values. Hiding an axis is a visual formatting change, not a data transformation. It does not sort the source data, alter the value range, or change the chart’s cumulative line. If the bars appear wrong, investigate the source data or axis scale rather than the label setting.

Tips

Be specific about what number labels mean before hiding them. If the left axis shows the number of reports and the right axis shows cumulative percentage, those scales answer different questions. You might hide the count labels to reduce clutter while keeping the percentage scale, or hide both when the values are already stated in a nearby table. Keep enough context for someone who did not build the chart to interpret it correctly.

Consider using an axis title when the axis numbers are hidden but the measure still matters. Select the chart, then use Chart Design > Add Chart Element > Axis Titles and choose the relevant axis title option. Enter a concise description such as Count of issues or Cumulative percentage. The exact options shown can depend on the chart’s axes. An axis title does not restore the numbers, but it clarifies what the scale represents.

If you hide the count labels, data labels on every bar are another option, but use them selectively. A Pareto chart with many categories can become crowded if every bar has a label and the cumulative line also has labels. You can select a series and use Chart Design > Add Chart Element > Data Labels to add labels, then choose a position that does not cover the line or neighboring bars. Check that the chart remains readable in print and at normal screen zoom.

Keep a copy of the original chart or note which axis you changed if you expect to revise the presentation later. Axis formatting is stored with the chart, so the setting generally remains after saving and reopening the workbook. If you replace the chart or create a new Pareto chart from updated data, however, you may need to apply the formatting again.

On Mac, select the axis and use the context menu’s Format Axis command; the formatting pane provides equivalent axis-label controls, though the pane layout can vary slightly by Excel release. In Excel for the web, select the chart and look for chart formatting or axis options. If you cannot find a control for setting label position to None, open the workbook in desktop Excel for Microsoft 365 and use the full Format Axis pane.

Troubleshooting

The numbers remain visible after choosing None. First check that you selected the axis whose labels you can still see. A Pareto chart can have a left value axis and a right percentage axis, and formatting one does not hide the other. Then reopen Format Axis > Axis Options > Labels and confirm that Label Position is still set to None. If the visible numbers are data labels attached to bars or the cumulative line, they are not axis labels; select the data series labels and remove or format those separately.

The Format Axis pane does not appear. Make sure the chart is selected, then click directly on a visible axis number or its axis line. Right-click and choose Format Axis. If the context menu instead offers options for a data point or chart area, click outside the chart to clear the selection and try again. You can also use Format > Current Selection on the ribbon to check which chart element is currently selected before opening its formatting controls.

The axis disappears, but so do gridlines or other visual cues. You may have deleted the whole axis instead of changing its label position, or you may have selected the gridlines. Undo the change, select an axis number, and set only Label Position to None. If the axis line or gridlines are already gone and undo is no longer available, use Chart Design > Add Chart Element to add the needed axis or gridlines again, then hide the labels through the Format Axis pane.

The chart looks misleading with no numbers. Restore the labels by returning to Format Axis > Axis Options > Labels and choosing a label position other than None, such as Next to Axis. Alternatively, keep the labels hidden but add a clear axis title or explanatory note. Avoid showing only the bars without any indication of what they measure, especially if readers may compare the chart with other reports.

The labels return after editing the chart. Check whether the chart was replaced, recreated, or copied from a source that uses different formatting. Selecting a new chart series or changing source data normally does not mean the axis labels setting was applied to both vertical axes. Reapply the setting to the relevant axis or axes, then save the workbook. If you are working in a shared or web-based file, confirm that the change has finished syncing before closing it.

Frequently Asked Questions

Can I hide the numbers but keep the Pareto bars?
Yes. Set the target axis’s label position to None. This hides its displayed numbers but keeps the bars and the axis scale used to plot them.

Does hiding the number axis also hide the cumulative percentage line?
No. The line is a separate data series. Hiding the count-axis labels should not remove it, though hiding the percentage axis labels may make the line’s scale less obvious.

Can I hide just one number on the axis?
For a standard axis, the label-position setting applies to all labels on that axis. To omit only one value, you would need a different chart-labeling approach; deleting a single axis label can be difficult to maintain as the chart changes.

Will the setting change when I update the source data?
Usually, the formatting stays with the chart when its source values change. A newly created or replaced chart may not inherit the setting, so check the axis after rebuilding the chart.

Can I hide the whole number axis instead of only its labels?
Yes. You can select and delete an axis, or use the chart’s axis controls to hide it where available. This removes more visual context than hiding labels, so consider keeping an axis title, gridlines, or another clear explanation of the values.

Why can I not find Label Position in Excel for the web?
Some web versions expose fewer detailed formatting controls than desktop Excel. If the axis pane does not offer Label Position, open the workbook in Excel for Microsoft 365 on Windows or Mac and set it to None there.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.