March 3rd, 2004, 03:19 PM
|
|
problems with scatter plot
Thanks - works great !
-----Original Message-----
lynn,
There are possibly unprintable characters or spaces in
the blank cells
that you are working with.
Let us say you are pasting values for the scatter graph
based on cells
A1:B10.
Now enter the following formula in c1 and copy to c1:d10
=IF(ISERROR(VALUE(a1)),NA(),a1)
Create the scatter graph based on c1:d10 instead of
a1:b10 but continue
to paste to a1:b10
This should prevent blanks and other characters from
showing up as
zeros.
- Lenin
---
Message posted from http://www.ExcelForum.com/
.
|