I have my tables which are reguarly added too but it is a pain going through the 20 odd charts updating the data range.

What i'd like to do is just select a huge area for the data range so i don't have to touch it again and the charts would auto update. The problem is i have told it to ignore blank cells but it still creates them on the chart space.

Is there any way to select a heap of cells but have it completely ignore the empty ones until there is data entered in them.