Dynamic Chart with blanks

[givensna]

I am using a combo box to chart a data series (prices) versus another
series (GDP) depending on a ticker. For some of my tickers, the data
doesn't go back as far as GDP does. I would like to cut off my chart
to only go back as far as my price data does for each ticker. I've set
up a dynamic chart, but instead of cutting off at the earliest price
date, it just plots zeros for the earlier, non-existant data points.
My prices column contains the following:
=IF(OR(B135="",B139=""),"",B135/B139-1). Why is excel plotting my
blanks as zeros here? Also, I have Tools > Options > Charts set to
"Not Plotted (leave gaps).

Any help will be greatly appreciated.

Thanks,
Andrew

 

[Peo Sjoblom]

Try


=IF(OR(B135="",B139=""),NA(),B135/B139-1)


then if you don't like the look of #N/A you can use white fonts and
conditional formatting



--


Regards,


Peo Sjoblom