How do i plot a data set that has one data point missing

  • Thread starter Bernard Liengme
  • Start date
B

Bernard Liengme

1) In the blank cell enter =NA() which shows as #N/A and is ignored by the
chart engine. Or if using formula use something like =IF(A1>0, B1/A1, NA())

2) Click chart; use Tools | Options; open Chart tab and specify how missing
data is to be treated.

best wishes
 
Top