Hey guys,

I've got a whole lot of data which i want to graph, but because there are alot of blank cells when I go to graph it excel goes spastic and the graphs turn out wrong.. I was just wondering if there was someway of filling all the empty cells with a zero (0) so that it gets graph'd properly? The autofill always gets copied over what I've got in the cells already

Cheers, J