ignore missing values while ploting graph
 

what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any
breaks in the plot

Excel plot Wrote:
what commands do i need to give in order to ignore the missing values
when i
am plotting the curve. By ignoring the missing values I will not get
any
breaks in the plot

Hi Excel plot

Use #N/A, this will be ignored


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467925

Using the ctrl key, only highlight the cells with values and Insert - Chart.

"Excel plot" wrote:

what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any
breaks in the plot