Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.

How to Stop Excel From Hiding the Zero. The presentation of an Excel document can be extremely important, especially if that document will be seen by business partners or clients.

When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same color by default. Another way to display the chart is to change the color of the ...