Selecting non zero cells for chart

[Mig35]

I would like to search through my range of values and select the cells (and maybe the heading 2 lines above it) so I can use the selection to create a chart. As there are many zero values only the non zero values are to be selected.
Thanks for any help

Mike

 

[Alisa]

I am interested to see if anyone has a solution for this - I tried to write something like this, and it ended up being too complicated to debug, so I just had the macro delete the "0" rows entirely.