Blank cells in line charts
 

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.


--
bluenose
------------------------------------------------------------------------
bluenose's Profile: http://www.excelforum.com/member.php...o&userid=26169
View this thread: http://www.excelforum.com/showthread...hreadid=394942