How to Hide Zero Values in Excel Chart (5 Easy Ways) Method 1 – Using the Filter Command to Hide Zero Values in an Excel Chart Steps: Select the entire dataset We will select the cells in the range B4:C9 Go to the Insert tab From the Chart group, select Recommended Charts Select any chart of your preference We will select the Clustered Column chart Click OK The chart will be