Thread: How do I chart missing data points in a scatter graph?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I chart missing data points in a scatter graph?
Alternatively, enter =NA() in the blank cells
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mickey" wrote in message
...
I figured it out, seconds later. I went Tools - Options - Chart

I then clicked "Not Plotted (Leave Gaps)"

ROCK!


Reply With QuoteReply With Quote