Excel Bar Chart Suppress Zeros

This shows a way to suppress zeros on a bar chart when using data labels.

[@robpickles3736]

Thank you very much! I thought I would find the answer easily on a website but no one seems to cover it. Thanks to Google and your great video it saved me so much time trying to work out. :)

[@keplanreet6480]

Nice, this has been an issue for me for Months. Such a simple solution and works so well. Thank you :)

[@anh-thupham2701]

Hi there! Thank you for this video. Do you know if there is a way to get rid of the Label Name in addition to the ##? When there is data I want it to display both the Category Name and % but when there is a 0 I don't want it to display either.

[@JayTariq]

This helped a lot. Thanks
I have a question. How do you remove a line from a "line graph". Yes zeros are removed but line still shows up.

[@itsatraplol]

Brilliant. I've been using the custom format of "##;" to remove zeroes, but it mucks with the numerical formatting. This is way better. Thank you!

[@dbradley9078]

Exactly what I was looking for. Thank you

[@pedroreis2578]

Thank you, you solved a problem that I had!

[@mgonzalezregueiro]

This just really saved me. Thanks!

[@casper3842]

Thank God i found the solution. Bless you!

[@stegalive]

OMG finally! Thank you!

[@ferd6197]

thank you for this tutorial

[@yasirilyasmalik4140]

Hello, I love you, this helped alot :)

[@rajeswarip6711]

Thank you so much i got the answer for my query.

[@casper3842]

Wow. Im looking for this solution in my lifetime.

[@Mario-tq6fd]

Brilliant! Thank you!

[@neranjankarunaratne1690]

Thank You !!!

[@madysanchi6759]

can the zero value be hidden like in the chart may and june is empty can it not be shown for the mean time?

[@userDEVmtb]

THANKS !!!!

[@kamranmammadli5850]

Now I try to remove these May and Jun with 0 values without filtering. is this possible?

[@allanpark6046]

Thank you

[@OmkarUmbre]

Can you please tell me if I want to hide columns in chart which have 0 or blank value?

[@Angel_268]

how to suppress the words may and jun on your chart when there is zero date?

[@WESTPRINGLE]

wow This problem has bugged me for years!

[@blackburd]

Ok now how do I NOT chart zero values?

[@MelodieWatts]

Thank you!!