Excel Charts - Missing Values

How do you create a chart in Excel that ignores missing values and come out
with a chart that has connected lines as if the values were there?

1) replace the missing values with =NA()
or
2) select chart; open Tools|Charts and adjust the setting for "Plot empty
cells"

best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"ediamond" <[email protected]> wrote in message
news:[email protected]...
> How do you create a chart in Excel that ignores missing values and come
> out
> with a chart that has connected lines as if the values were there?

Replacing the missing values with =NA() produces an error in the cell,
however, leaving them empty and changing the Plot empty cells to
"Interpolated" fixed the problem. Thank you for leading me in the right
direction.

"Bernard Liengme" wrote:

> 1) replace the missing values with =NA()
> or
> 2) select chart; open Tools|Charts and adjust the setting for "Plot empty
> cells"
>
> best wishes
> --
> Bernard Liengme
> www.stfx.ca/people/bliengme
> remove CAPS in email address
>
>
> "ediamond" <[email protected]> wrote in message
> news:[email protected]...
> > How do you create a chart in Excel that ignores missing values and come
> > out
> > with a chart that has connected lines as if the values were there?
>
>
>