Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Display Or Hide Zero Values. In a chart there are no items. You may also lie away zero values using the format code with a third part for the zero case.
Actually 0 values are marked in white color. In a chart there are no items. To display zero 0 values back in cells check the Show a zero in cells that have zero value check box.
Its up to you whether you want to show.
If you deactivate either of the zero value options. Go to File Options. Actually 0 values are marked in white color. If you deactivate either of the zero value options.