Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello everyone,
I have a line chart that plots the evolution of an economic indicator over the months. Each of the 12 cells plotted (the source range) has a formula. It fetches a value from a dabase. For all the months to come, the formula shows "" (like empty cell) or a blank (" "). I might use zero, were it needed. But what I need is that beyond the current month, the line makes a gap (no dots) instead of treating formulas as zeroes. Are there any parameters or options that could help me? Thank you Vicente Soler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula result blank | Excel Worksheet Functions | |||
How to get Blank into a cell as a result of a formula | Excel Worksheet Functions | |||
Pasteing formula gives blank result | Excel Worksheet Functions | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
IF statement when formula result is blank | Excel Worksheet Functions |