Thread: Avoid charting zeroes?

I am trying to graph a single point on a chart with several line graphs. Depending on what the user will input, this point will change, so I need to have the series linked to several cells, not just one. I have the data for this point set up like I would for a line it is linked to a cell in an input worksheet. Is there a way to just not chart the zeroes as points or can I create an "IF" function that will give a "no entry" value rather than act like a zero?

To me, everything I did is pretty complicated, so I'm not sure if this is the best way to explain it, but any help on this would be appreciated.

Thanks!

Thanks so much, I had a feeling it would be very easy.