Remove zero in Pivot Chart

Question

Good afternoon,

How do we remove zero from the chart, so it looks cleaner.

Thanks,

Therence

Answer 1

Good morning Snow,

Thanks for the follow-up. I was able to fix it by starting a new one.

Regards,

Therence

Answer 2

Could you share a test file? Then I can help you correct the settings on your pivot table.

Answer 3

You may use custom number format on Value field settings.

0;-0;;@

If it doesn't you want, share a test file with some dummy data in it? Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.

Good morning,

Following your instructions I clicked the pivot chart but it doesn't show pivot table fields (unlike the old file below). Pivot table is fine, no zeroes .

So I'm clear. I copy pasted it from my old file (below). I cannot remember how I did it. Is there a way copy the settings?

Thanks,

Therence

Answer 4

You may use custom number format on Value field settings.

0;-0;;@

If it doesn't you want, share a test file with some dummy data in it? Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.