Creating Graphs Without Blanks Showing As Zeroes

[adambgoldstein]

I am trying to create a line graph based on the months of the year and a percentage. The percentage is based off of a formula, so if the numbers that are part of the percentage are zero and zero (because the month hasn't happened yet) it comes up as "#DIV/0!". When I graph this information, any cell that is "#DIV/0" comes up as zero instead of not graphing at all. I have tried adding in a qualifier to make the cell " " when it divides zero by zero, but that still shows up as zero in the graph even though the cell shows up as a blank. Below is the data set I am working with. Once it gets to Jun, the line graph shows zero through Dec. Is there a way to have the graph not plot for non numbers? Thank you!

Month	Percent
Jan	100%
Feb	50%
Mar	25%
Apr	100%
May	60%
Jun	#DIV/0!
Jul	#DIV/0!
Aug	#DIV/0!
Sep	#DIV/0!
Oct	#DIV/0!
Nov	#DIV/0!
Dec	#DIV/0!

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[mole999]

whats the formula you are using

 

[adambgoldstein]

I'm just dividing two numbers. So, for Feb, it would be something like C3/D3 and B3 would be .5 (or 50% when formatted) where C3 is 5 and D3 is 10.

 

[63falcondude]

You can use IFERROR to change your errors to #N/A (which will not be graphed).

That is:
=IFERROR(your_formula,NA())

 

[adambgoldstein]

That works! Thank you so much! I have been trying to figure this out for a while!

 

[63falcondude]

You're welcome, happy to help. Also, welcome to the forum!

Just FYI: You can Conditionally Format the cells with #N/A to have white font so you don't see them.

This would be for aesthetic purposes only.