| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL
The way i do it is
=IF(C64=0,"",SUM(X64*1000)/C64) Works for me "AJ-foster" wrote: i have a chart which is populated by formulas on a monthly basis but the line graph reads blank cells which has formulas but not data in as a ZERO value which makes the line graph drop to zero at which ever point the last monthly figure goes in is there away of the series fuctiion that reads the range not read the formula as a value but as a blank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Can a formula display output to an otherwise blank cell? | Excel Worksheet Functions | |||
| How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
| How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Hybrid Mode
