| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show current value
Hope someone can help
I have a sheet linked to a chart linked to the PowerPoint report. The sheet column B-M is the months Row 2-7 is years (2005-2010) The data is then put into a chart In Cell I21 I have =IF(K32000,"CLVs Met","CLVs Not Met") K3 is Oct 06 and has a value of 2100 so I21 comes back as CLVs Met Question can I have I21 show (change) to the newest data that was put into another cell without changing the cell (I21) each time? So if I put in a value of 1200 into L3 (Nov 06) I21 will show €śnot met€ť Thanks James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some charts will not show trendlines | Charts and Charting in Excel | |||
| show current list | Excel Discussion (Misc queries) | |||
| show current list | Excel Discussion (Misc queries) | |||
| add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22) | Excel Discussion (Misc queries) | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
Threaded Mode
