Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Person Names Smart Tag problems | Excel Discussion (Misc queries) | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
smart charts | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) |