Create chart from dynamical values

Hi!
I've got this Excel sheet which has a lot of numbers in it based on data from an accounting database. This Excel sheet has a macro that updated the data in the Sheet.

I want to create a few graphs from this data. So I created a new sheet that basically has a formula in each cell that says this:

=IF(Sheet1!E2<>0;Sheet1!A2;"")

The same formula is repeated in each cell in each row, only the next row has it slightly altered:

=IF(Sheet1!E3<>0;Sheet1!A3;"")

=IF(Sheet1!E4<>0;Sheet1!A4;"")

=IF(Sheet1!E5<>0;Sheet1!A5;"")

And so on and so forth.Once the cell E in one row is nothing or 0, the value will be nothing.

This formula is repeated to row 60. And what I want is to create a graph from this whole area. But the graph picks up the values that are nothing as well. Making the chart look weird. So I want the graph to pick up the values if they are anything but nothing.

Is this possible? Or would I have to manually change the chart data range each time the Worksheet is updated with data?

Edit: The Chart data is selected like this:

=Numbers1!$D$2:$D$60

And this basically says to pick the range in Sheet "Numbers1" from cell D2 to D60. But the thing is, most of these cells might be empty. But they could have values. And I don't want to edit the chart if that happens. It should all go dynamically.

Edit2: Added a screencap of the Excel sheet, which data I select and how it all ends up in the graph. Notice how some of the cells have nothing in them? Well, they do have the formula mentioned above. Which is why the cells looks to be empty. Anyway, I really want the graph to just stop at that point. If it reaches a cell that has nothing in it, then that cell shouldn't even be added to the graph. Don't know if this is possible without any macro code? If it's only possible using macros, I'd have to use macros I guess.