Area chart dives to zero when data series stops

[DannyS]

I have a series like so:

Jan 10,11,13,12
Feb 10,12,13,12
Mar 11,11,13,14
Apr 12,13,13,13
May
Jun
Jul

And so on - the rest of the year is blank. When I draw an area chart for the
full 12 months the series draws an area up to April, then plummets to zero in
May. I want the area to just stop at April. My cells use the formula
=IF($A11<=$D$17,G11,NA()) therefore, the NA stops any line charts goinf
beyond April, but the area chart is more problematic.

Please help!!

 

[Jon Peltier]

The NA() or #N/A trick only works with charts that also accommodate a
marker, such as line, XY, and some radar charts. In an area chart, you could
use a date axis with double values at the point where you want a vertical
edge, as in this example:

http://peltiertech.com/Excel/Charts/XYAreaChart.html

which admittedly is a pain to set up. You could instead set up a dynamic
range that includes only numeric values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax
(e-mail address removed)
http://PeltierTech.com/
_______

 

[DannyS]

Cheers Jon - it's working! you are a charting legend.

Great stuff.