alexaronson
Active Member
- Joined
- Sep 30, 2005
- Messages
- 314
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
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