If I plot a line chart on a series of data and leave a blank in the row the graph leaves a corresponding gap in the line.
I am trying to replicate this effect when the data series comes via formulae. I have tried getting the formula to return an empty string ("") and various error values but in each case the graph either directly connects the adjacent values or connects them via 0.
Anyone any ideas? (without using VBA)