Hiding 'zero' values from the chart data range

Dear Excellians!

I am currently building a tool that works with an undefined range of input variables, e.g. I now have a range of 200 values but it could just as easily be 400 or 100. I am using these values for further calculations and have thus 'dragged down' to cells that in some instances are empty, resulting in values that are 0. I'm also building a chart based on these values, but it shows the values that are 0 as well!

Is there any way to just plot the non-zero values without changing the data range?

Any thoughts are very appreciated and will be rewarded with a digital smiley.

My apologies, it seems romperstomper already provided the answer in this thread.