It looks like you can do this by using 2 series and 2 trend lines.
The second data series is adjusted to only include those cells with data.
Add trend line to both series.
The trend line on the complete data set is used to display the dashed trend line segments.
The trend line on the incomplete data set is used to display the solid trend line segments.
Bookmarks