Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges where #N/A is returned in the source cell using the N/A() function. I have "show empty cells shown as gaps" selected.

Any bright ideas!?

share|improve this question

Your formula can return NA() or "", but neither is interpreted as a blank cell: one's an error value, and the other is a short text string. The marker for NA() is omitted, and the line connects points on either side of the NA(). A marker for "" is placed at zero, since Excel interprets text as zero.

You have to manually or programmatically delete the contents of a cell in order for the chart to consider it a blank cell. Or you could manually or programmatically format the connecting line that spans the non-blank cell to use "no line".

Not the bright idea you wanted, but these are the best I've ever come across.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .