Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank cells in line charts | Excel Discussion (Misc queries) | |||
Blank cells represented in area charts | Charts and Charting in Excel | |||
Charting of Merged Cells | Excel Discussion (Misc queries) | |||
Plotting blank cells in line charts? | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel |