If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
problems with scatter plot
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 |
Thread Tools | |
Display Modes | |
|
|