View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
vsoler vsoler is offline
external usenet poster
 
Posts: 79
Default I need a gap when the result of a formula is blank or zero

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