B
bluenose
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.
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.