#N/A still being plotted
If you're simply typing #N/A in the cells, that value will be text, not an
error....
Use this function instead: =NA()
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Paquet" wrote:
Hi,
Here is my problem, I import a txt file wich the number of rows varies. And
I want to make a macro that plot the ''good'' value. I tried to put #N/A
everywere, because they are not suppose to be plot... But they are still
plot! Even by changing option:ToolsOptionsChart tick in Plot visible cells
only.
ex:
2006-07-03 34 65
2006-07-04 65 76
2006-07-05 98 90
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
I'm looking for a solution since a month! Any other idea?
Thanks a lot!
|