#N/A still being plotted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:Tools>Options>Chart> 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!
 
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
 
Hello Ron,

Unfortunatly, That's what I did.

Ron Coderre said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting with a macro or a formula 8
Select N rows and get Minimum 4
How do I plot date against time? 8
Graphing problem - data with multiple series 1
Problem with trendline formula 2
Generating time based series 1
Not plot a data series in a chart but still display in data table 1
blank vs. 0 when plotting a dated timescale graph 1

Back
Top