| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a formula ignore empty cells? | Excel Worksheet Functions | |||
| eliminating empty cells from chart area | Charts and Charting in Excel | |||
| Ignore N/A values with an area chart | Charts and Charting in Excel | |||
| Trendline to ignore empty cells | Charts and Charting in Excel | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
Linear Mode
