View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] danielkim444@gmail.com is offline
external usenet poster
 
Posts: 1
Default area chart won't ignore empty cells, data descends to zero

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