Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 18, 01:39 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a formula ignore empty cells? Melissa Excel Worksheet Functions 1 March 31st 06 06:24 PM
eliminating empty cells from chart area financeman500 Charts and Charting in Excel 1 February 22nd 06 05:41 PM
Ignore N/A values with an area chart SPeterson Charts and Charting in Excel 1 November 14th 05 05:14 PM
Trendline to ignore empty cells Kara Charts and Charting in Excel 0 June 9th 05 05:39 PM
Trendlines to ignore empty cells Hoochi Coochi Man Charts and Charting in Excel 7 January 14th 05 02:31 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017