Thread: 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" <ediamond@discussions.microsoft.com> wrote in message
news:C311C706-7319-4E60-86DA-4777239D3B6F@microsoft.com...
> 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" <ediamond@discussions.microsoft.com> wrote in message
> news:C311C706-7319-4E60-86DA-4777239D3B6F@microsoft.com...
> > 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?
>
>
>