| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What variable do you insert for X-cel if there is missing data?
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. |
|
#2
|
|||
|
|||
|
If you enter "#N/A" (without quotes) or the formula =NA(), then that
will be ignored in the chart display. In article , "Iop.kcl" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert picture | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
Linear Mode
