What variable do you insert for X-cel if there is missing data?

I

Iop.kcl

We are entering data on questionnaires completed by parents and drawing
graphs from these. However, where data is missing X-cel gives a value of 0
which is scewing results. We are wanting to know what variable to use for
missing data.
 
J

JE McGimpsey

If you enter "#N/A" (without quotes) or the formula =NA(), then that
will be ignored in the chart display.
 

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

Adding data to MS Access from csv file 0
Goal Seek with variable Set Cell 1
Inability to add quotation mark around a variable by concatenation in VBA 4
VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
How do I run a query using multiple conditions? 1
Constant % on X axis 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0

Top