• 512-991-7197
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Always Open

Welcome to Microsoft Excel Tips & Tricks

How to hide points on the chart axis


Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 
1

To hide some points in the Excel 2016 chart axis, do the following:

   1.   Right-click in the axis and choose Format Axis... in the popup menu:

2

   2.   On the Format Axis task pane, in the Number group, select Custom category and then change the field Format Code:

# ###;- # ###;;

3

The first applies to positive values, the second to negative values, and the third to zero (for more details see Conditional formatting of chart axes).

   3.   Click the Add button.


© 2015 - 2020 Austin Laptop [AustinLaptop.Com]. All Rights Reserved.