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?

Excel Charts - Missing Values
 

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" wrote in message
...
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?

Excel Charts - Missing Values
 

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" wrote in message
...
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?