Add Series Line to portion of data set

[tim_excels]

I want to add series lines to an XY scatter plot but control which data points are connected (and not connect the whole series).
I haven't found a way to do this, I'm wondering if anyone has any tricks.

I know I can create separate series to resolve this, but the data categories repeat themselves, so it becomes inefficient.

I want to connect data between each 8 hour period in a day only, and I don't want a straight line between the same 8 hour period from one day to the next.

Interested to hear any feedback on this.

Cheers

 

[pgc01]

Hi
Welcome to the board

If I understand correctly you want to break the line at some points.

If that's correct, to break the line just make segments invisible.

Try this:
Click at one segment 2 times (not double-click, click one time, this selects the whole line, then click another time on the segment and you'll see that only that segment is selected).
Format the shape outline as "No outline"

... or do the same thing in vba (if you don't know how you can start by recording a macro while you do it manually).

HTH

 

[tim_excels]

Perfect Thank you!

 

[pgc01]

You're welcome.