Excel Charts - Missing Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top