Chart ignoring formulas but only plotting formula results

J

JD

I am creating a line chart where the source data is the result of an =IF
formula. How do I get the chart to only plot the cells where there is a
result? Currently the chart is plotting a zero value for all the cells where
the formula does not yet show a result.
 
B

Bernard Liengme

If( something, formula, NA() )
The otherwise blank cells now have #N/A in then (you can hide these with
Conditional formatting if they bother you)
Charts ignore these values
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

Non Linear Scatter plot, need to find y value 3
Blank instead of "" 5
Timeline Plots 0
Plotting NA() or #N/A data points 1
How do I not plot zero values that result from a formula in Excel? 1
Impossible? Not plotting NA()s 2
Surpressing plot of blank cells 4
Data Range Question 1

Top