Remove Zeros from chart labels

Please sign up for the course before starting the lesson.

Occasionally you have a chart where the data is blank, but on the chart you see zeros for the labels as shown below.

Remove zeros from Chart Labels

One way to get rid of this is to create a custom format for the numbers where a zero is shown with a blank.

To see the full course contents click here.

Back to: Advanced Excel Course > Charting In Excel