• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

BAR CHART excludings 0

srinidhi

srinidhi

Active Member
I have a bar chart for which data is stored in A3:D6.

The bars should not be displayed if the data in B2:B6 is 0 or c2:c6 is 0. Each time the data changes I am manually selecting the data, is there any formula for automatically not displaying the bars if the entire column contains 0.
 
In A2 you could use a formula like

=IF(COUNTIF($B$2:$C$6,0)>0,Your Formula,"")


Put your existing formula or value in where it says "Your Formula"

You can copy that down to A6


Adjust ranges to suit
 
You must log in or register to reply here.
Back
Top