Is it possible to create a scatter plot using a range of
data but have it ignore a cell if it's blank ? I have a
range of data copied @ pasted from another source.
The 'blank' cells seem to be behaving as zeros, resulting
in a problem with the scatter plot. If I click in the
blank cell and delete, the plot reports correctly. I'm not
going to be able to manually remove the blanks, however.
Is there a way I can have Excel ignore the blanks when
creating the chart ? Using excel 2002