How to Hide Zero in Axis in Chart

When work with a chart, you may want to hide the 0 in the Y-Axis. To hide 0 in the Y-Axis, please follow the steps below:

Step 1: Right-click the Y-Axis, then click the "Format Axis" in the dialog box;

Step 2: In the "Format Axis" window, under "Number" section, change the format code from "#,##0" to "#,###", then click "Add", zero will be removed;

Step 3: The following is the chart with no 0 on the Y-Axis.

Download Example

Leave a Reply