|
Return to Newsletter Contents...
Displaying Nulls in Line Charts
by: Aaron Zechman, Consultant
There are three different ways to
display NULLs in line charts and which one you choose will depend on how your
audience wants to see the table. The
three ways are to break the line in the chart, connect the line by dropping to
zero and connecting the line without dropping to zero.
Let us start out with a simple table
displaying products and sales.
| Products |
Sales |
| Hats |
35 |
| Coats |
340 |
| Headbands |
NULL |
| Pants |
65 |
Break the line in the chart
In order to use this method, use the
following two steps
1.
Underneath the file menu, click on the
report options and then make sure the ‘Convert Database NULL values to default’
is not selected.
2.
From the chart menu, select chart options and on the appearance tab select the
‘Break lines for missing data’.
You should get the following result.
Connecting the Line by Dropping to Zero
For this option there is only one step
to perform to make sure it works.
1.
Underneath the file menu, click on the report options and then make sure the
‘Convert Database NULL values to default’ is selected.
The results should appear as the following.
Connect the Line Without Dropping to Zero
For this option there is only one step
to perform to make sure it works.
1.
Underneath the file menu, click on the report options and then make sure the
‘Convert Database NULL values to default’ is not selected.
The results should appear as the
following.
Go to Top |
Return to Newsletter Contents
|
