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

Smart charts. Is it possible?
 

You might come up with some clever formulas, which can be fed into dynamic
ranges and a dynamic chart.

Dynamic charts:

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

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


"kras" wrote in message
...

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