View Single Post
  #2   Report Post  
mangesh_yadav
 
Posts: n/a
Default


Let the matlab put data in your specified cells, lets say A1:B10. In
another column, say C1:D100, enter the formula
=IF(A1="",NA(),A1)
in C1 and copy down for the max number of rows you want to put as a
range for the graph. And in D1 similarly enter and copy down the
following formula:
=IF(B1="",NA(),D1)

Link the columns C and D to your graph.

When the columns A and B are blank, the corresponding rows in columns C
and D will have #N/A which is ignored by the graph.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374485