In an Access form with a chart I have time (weeks) along the x axis (bottom) and cumulative values expressed as lines.
Some fields have values to the end of the time line (eg Budget) others show vlaues up until the current time (eg expenditure) and should stop where the values become null.
Currently these lines descend to zero instead of terminating where the values become null.
There should be somewhere I can set teh line properties for empty points to become invisible.
Where is it?