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
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 89:19:12 |
Calls: | 6,496 |
Calls today: | 7 |
Files: | 12,100 |
Messages: | 5,277,442 |