Excel 2013 How to not plot data errors

[alexaronson]

Hello and thank you for looking at my question.

I have Excel 2013. I have a table that I will be updating fairly regularly to populate a graph. In the table there is formula for the entire range that I want to graph. However, for certain days in the graph, I have missing data or data that has not come in. As a result of the formula, I am getting #VALUE! error. When I go to graph my data, the cells with the #VALUE! error are charting with a value of 0.

How can I make excel ignore the error and create a gap in the chart?

I have tried various iferror formulas to get different output for the cell. However non of those appear to work.

Thanks again for looking at my question.
-Alex

 

[gorem]

This is an interesting way around the issue you are experiencing. I'll let you know if I think of something more intuitive:
Another approach to plotting gaps in Excel charts - Peltier Tech Blog

 

[gorem]

This may also be useful for you. Again, I'll post an actual solution when I have time

http://www.exceldashboardtemplates....-line-chart-when-using-the-excel-na-function/