MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graph a conditional range

Posted by Marshall Holstrom on November 08, 2001 11:33 AM

In my spreadsheet, I have two data ranges, one to enter a monthly number and one to show the year to date amount. I use an IF formula to enter a number in the YTD column if the monthly number exists or a null "" if there is no monthly number. However, when I graph the YTD range, all the null values graph at zero.

Is there a way to select the entire data range to graph, and have cells containing a formula returning NULL not show on the graph?

Posted by Mark W. on November 08, 2001 12:59 PM

In your IF()... use #N/A rather than "" (nt)