Generating a graph from excel
August 14, 2015 12:52 PM Subscribe
I have an excel file with two columns that I'd like to somehow (in the easiest way possible) turn into a graph (in the graph theory sense - with nodes and edges).
The first column lists the originating node and the second column lists the terminal node. So, if the first column is "A" and the second column is "B", I'd like the software to be able draw an arrow from node A to node B. It would be ideal if there was some software that I could download, but if the tool is online only, that's ok too. I use Windows 7 and Ubuntu 14.04.
The first column lists the originating node and the second column lists the terminal node. So, if the first column is "A" and the second column is "B", I'd like the software to be able draw an arrow from node A to node B. It would be ideal if there was some software that I could download, but if the tool is online only, that's ok too. I use Windows 7 and Ubuntu 14.04.
Take a look at FreeMind. You can copy and paste from Excel (after some formatting) into FreeMind.
posted by jcatus at 1:03 PM on August 14, 2015
posted by jcatus at 1:03 PM on August 14, 2015
`dot' in the graphviz package draws directed graphs. There is a gallery of examples.
posted by fritley at 1:28 PM on August 14, 2015
posted by fritley at 1:28 PM on August 14, 2015
It's online, but Google Fusion Tables will do this. Their examples have three columns, but I can confirm it works with two as well. You can upload your Excel table.
posted by betafilter at 5:14 PM on August 14, 2015
posted by betafilter at 5:14 PM on August 14, 2015
« Older Need a camera / camcorder with clean HDMI out and... | Mystery itching problem, I think i've tried... Newer »
This thread is closed to new comments.
posted by noneuclidean at 1:00 PM on August 14, 2015 [1 favorite]