Ask Your Question

connect cells with lines

asked 2018-09-04 01:56:36 +0200

duehew gravatar image

I have a simple spreadsheet with numbers in various cells. How do I connect them with lines from one cell to the next? Thank you.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-04 02:30:28 +0200

Ratslinger gravatar image

updated 2018-09-04 02:42:52 +0200


See this post -> Python macro for Calc to correlate two columns with string data

The instructions to do this manually are in the question. Result is as such (here selected same cell):

image description

There is also a Python macro in the answer which can automate the process. Have never really examined this closely but remember testing the posted code. Here is sample output:

image description

Doesn't appear to work for numbers as written but may be of help as a starting point.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-04 01:56:36 +0200

Seen: 35 times

Last updated: Sep 04 '18