• area chart won't ignore empty cells, data descends to zero

    From danielkim444@gmail.com@21:1/5 to obe one on Tue Jan 30 16:39:52 2018
    On Saturday, October 28, 2000 at 1:18:05 PM UTC-7, obe one wrote:
    I have an area chart of costs per month, with data to september, and a time scale to december. The chart, instead of just stopping at september, drops down to zero at october.

    I have tried, unsucessfully, the following
    -options > chart > empty cells not plotted
    -stopping data ranges at september, but then the x axis also stops at september
    -the same as previous, using a mixed chart type (with a line chart) to have the line extend to end of time series, formatted white color to be
    invisible, but xl did not like mixing line and area chart.

    THis isn't rocket science, is the avdabavda neebaarea chart buggy for the empty cell option
    and is this fixed in xl2000?

    I have tried this at work and at home and same result.

    thanks

    doug

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)