Projecting data a future?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am charting a Project's cash folw, over a 12 month period, how does one
plot cells where there are blanks or 0 values or cells with formulas. My
data fall's to the base 0 line when there are no data in the cells. I would
prefer the ploted range Chart line stop, in mid air, in the actual sheet

XP, 2003 office.

Please Help
Leroy
 
Hi,

Empty cells should be ok. But for those containing formula use the
function NA() instead of 0's.

Cheers
Andy
 
Leroy -

Use NA() in place of "" as well, because "" isn't blank, it's a text value, which
Excel plots as zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top