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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't plot non-numeric cells 2
Don't want to plot blank cells on my chart 4
Cannot find "Plot empty cells as" option in 2007 8
Missing data 2
conditional formating to keep the #N/A error from being visible 5
How a blank cell is treated in a Chart (Series) 1
How do I list all Data in a column that fits between two points? 2
How would I plot this kind of data in a line chart? 2

Top