19. Now we need to hide the zeros overlapping with the blue bars. To do that, I need to change the number formatting of certain numbers. Select cell C6, and on the Home tab, in the Number group, click on More Number Formats at the bottom of the Number Format list.
20. In the Format Cells dialog box, under Category, click Custom.
21. In the Type input line, type ;;;. Click Ok to close the Format Cells dialog box.
22. While cell C6 is still selected, double-click the Format Painter icon in the Clipboard group on the Home tab. Next, click on the other cells (C9, C12, C15, etc.) to automatically apply the same custom number format to these cells. When done, press the Esc key on the keyboard and the worksheet should look like this: