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!