Need to create a diagram of connected points
Spreadsheet looks basically like this: Across the top row and down column A are sites., in order. If there is a connection between "Site A" and "Site B" the "Site A" row will have TRUE in the "Site B" column, and vice versa. If there is no connection it will be "FALSE," if we failed to connect to "Site A" to test the connection to "Site B" that column will say "Diag Fail," and finally "Site A" to "Site A" has the value "Self".
What I would like to generate is a series of dots in an image for each of the sites, and then a line that connects them if there is a connection. I'm pretty sure I've seen this done in a pivot table in the past, but it's been too long.
Edit: Stole u/bradland 's example screenshot. This is what my source data looks like
[link] [comments]
Want to read more?
Check out the full article on the original site