#N/A still being plotted
 

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!

#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!

#N/A still being plotted
 

Hello Ron,

Unfortunatly, That's what I did.

"Ron Coderre" wrote:

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!