Heide column chart with zero values in Excel

[MAlhash]

Good morning, everyone!

I am trying to create a dynamic chart in Excel. However, I want to hide the columns in Bar chart with contains zeros because it looks too much crowdy. I used the zero filters, but it hides for me the whole column. my problem that each category has 4 bar chart I just want to hide the bar which contain zero for that category but not to hide the category itself only if the category itself showed zero for all its bar chart.

I hope that I have explained the question clearly.

I will attach one picture to make it easier.

Thank you!

 

[vladimiratanasiu]

Good morning, everyone!

I am trying to create a dynamic chart in Excel. However, I want to hide the columns in Bar chart with contains zeros because it looks too much crowdy. I used the zero filters, but it hides for me the whole column. my problem that each category has 4 bar chart I just want to hide the bar which contain zero for that category but not to hide the category itself only if the category itself showed zero for all its bar chart.

I hope that I have explained the question clearly.

I will attach one picture to make it easier.

Thank you!

Did you try it? How to Hide Zero Values in Excel Chart (5 Easy Ways)

 

[MAlhash]

Did you try it? How to Hide Zero Values in Excel Chart (5 Easy Ways)

Thank you for your response. Yes, I have tried it. It will hide the whole category with all their data. I just want to hide the sub column which contain the zero.

 

[vladimiratanasiu]

See if it helps you: How to keep "zero" value bars hidden in an excel chart [SOLVED]

 

[MAlhash]

See if it helps you: How to keep "zero" value bars hidden in an excel chart [SOLVED]

sorry Sir, but it did not help me. Maybe what I am asking for can not be done in excel.
Thank you