View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kras kras is offline
external usenet poster
 
Posts: 1
Default Smart charts. Is it possible?


Hi,

I've been trying to implement a task that is out of my humble MS Excel
knowledge and any help will be much appreciated.

I have a table with integer numbers that is dynamic. It means that if I
change a cell value outside this table its cells change to zero or an
integer number. For example, if I change the value /in my case: date/
of the outside table cell all table cells that don't meet that
requirement return zero and the rest return integer numbers. The table
is constructed date-by-date, so the zero values come at the top of it,
followed by integer numbers only, no zero values. My purpose is to
construct a chart that takes only the integer numbers of that table and
avoids the zero values at its top.

I look forward for any ideas...

Regards,
kras


--
kras
------------------------------------------------------------------------
kras's Profile: http://www.excelforum.com/member.php...o&userid=28667
View this thread: http://www.excelforum.com/showthread...hreadid=574085