ignore missing values while ploting graph

[Excel plot]

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

[Paul Sheppard]

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

[Mike]

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