LinkBack URL
About LinkBacks
Hi,
I want to hide bar if it has zero value.
Rep 1 - $5000
Rep 2 - $3000
Rep 3 - $0
Rep 4 - $4000
The chart should have only 3 bars for Rep 1, Rep 2 and Rep 4. I don't want to show zero value bar. Is it possible?
Hi,
I want to hide bar if it has zero value.
Rep 1 - $5000
Rep 2 - $3000
Rep 3 - $0
Rep 4 - $4000
The chart should have only 3 bars for Rep 1, Rep 2 and Rep 4. I don't want to show zero value bar. Is it possible?
you can untick zero-values in Horizontal (Category) Axis Labels
zero.jpg
Thanks Sandy for your response.
It looks like manual work every time. Is there any way for dynamic?
maybe with VBA because 0, #N/A or blank cell will give a gap on the chart
also you can hide this row, but this is not automatic
Last edited by sandy666; 07-26-2017 at 06:52 AM.
You could create another table that pulls only non-zero rows from the data and uses that as the chart's source data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes, Ali's suggestion is very best.
Thank you both Ali and Sandy.
You're welcome!
welcome and thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks