How do I set up a chart to only chart values greater than 0

D

debra49424

I have a chart in Excell that I would like to only have chart those items
with a value of greater than 0 (zero). Not sure if there is a better, easier
way than having manually manipulate the data.
 
B

Bernard Liengme

Let's say the values are in B1:B20
In C1 enter =IF(B1>0,B1,NA())
Now use column C for the chart; the displayed #N/A values will be ignored by
the chart engine
best wishes
 
A

Adrienne

This topic wasn't the reason I was looking through this discussion board but
I can definitely use the information!
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Network Diagram using a Chart SW integration 0
How to create a bubble chart with more than 2 variables. 0
Creating a Chart on form from selected data in query. 0
Possible to Combine reports to's to a single box? 0
One extra x axis item that wont go away - can anyone help? 3
How do I get source data to show on a chart only if greater than z 4
Chart SERIES OFFSET 5
Aggregating Data in Other Category on Pie Chart 2

Top