LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Pat
 
Posts: n/a
Default Area charts and blank cells

Hi,

I'm trying to plot costs vs. time (month) on an area chart. I want to split
up the costs by time, so I've created a bunch of different data series which
look something like:
Jan Feb Mar Apr May Jun
$2 $6 $1
$1 $3
$3 $8 $4

This is basically just breaking up the original data series... ie
Jan Feb Mar Apr May Jun
$2 $6 $1 $3 $8 $4

I was hoping this would produce a nice, continuous area chart sectioned off
by colour. The problem is that it interprets the blank spaces as zero and so
I get these weird edges at the end of series... like going from $3 in Apr to
$0 in May. What I would like it to do is just drop straight down from $3 to
$0 in Apr (so just a vertical line). Any way to do this?

If there's a way to shade under line graphs, that would also do the trick...
because those don't plot blank spaces as zero. Thanks for your help!!

 
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
Blank cells in line charts bluenose Excel Discussion (Misc queries) 0 August 11th 05 02:54 PM
Blank cells represented in area charts cdoughty Charts and Charting in Excel 2 August 6th 05 06:02 PM
Charting of Merged Cells znb74 Excel Discussion (Misc queries) 0 April 15th 05 02:42 PM
Plotting blank cells in line charts? doogie Charts and Charting in Excel 3 February 16th 05 05:06 PM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 10:43 PM


All times are GMT +1. The time now is 09:30 PM.

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

About Us

"It's about Microsoft Excel"