How to chart #NUM!

A

Ali Baba

I want to create a chart and in some cases I get #NUM!. If I plot the chart
#NUM! = 0, is there a way not to include the cells with those values.
 
B

Bernard Liengme

You #NUM! error must come from a formula. Let's say it is =A1/B1. Replace
this by
=IF(ISERROR(A1/B1),NA(), A1/B1) Now in place of the NUM error you will get
NA() and charts ignore this.
best wishes
 

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

Filtered view of Visio Chart 0
Drop down list control value in vba 2
Line and scatter chart in a single chart sheet 0
Move Chart with Text 0
How to create a bubble chart with more than 2 variables. 0
How activate "NUM" thingie? 10
Non Linear Scatter plot, need to find y value 3
How to getting text labels to show up in scatter chart. 0

Top