• 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.

When a Value Equals zero in a chart, how do I keep it from appearing?

T

theseansun

New Member
Hi there,


I'm trying to create a bar graph where that shows the porduct name and the number of the product that's ordered. I only want it to show products that haave been ordered (a value greater than 0) and not show the products that havent been. What formulas can i go about using to do this? Right now I have two columns: "Product name" and "# Ordered".


Thanks!
 
Theseansun


Firstly, Welcome to the Chandoo.org forums


There are two ways to do this


1. You can extract a subset of data from your data source which excludes the Zero values

Refer: http://chandoo.org/wp/2011/11/18/formula-forensics-003/


2. You can jump across the blank values using some techniques described here:

http://chandoo.org/wp/2012/12/04/formula-forensics-no-032-creating-dynamic-charts-with-non-contiguous-data/
 
You must log in or register to reply here.
Back
Top