graphs

J

Jo

Hi
In the following data set how do I prevent n/a plotting as
0?
Thanks
Jo


value day
3 1
3 2
N/A 3
3 4
3 5
3 6
 
D

Debra Dalgleish

Instead of typing N/A, enter the formula: =NA()
This will display as #N/A
 

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

Plotting Graph with dynamic table 3
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Creating Different Headers in Word 0
Countdown macro - display settings 2
Outlook 2010 can't find .pst file 1
Paragraph numbering in Word 1
Word- Find and Replace 1
Plotting against Date (collating months) 2

Top