Thread: 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.

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

In article <36FC208B-BAAE-4CF5-B3EC-A18FBEDE3EE5@microsoft.com>,
"Iop.kcl" <Iop.kcl@discussions.microsoft.com> 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.