Area chart dives to zero when data series stops

G

Guest

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!!
 
J

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top