Hi, this looks to me as a graph and this is the way it should be visualized.
I have written a small Livecode stack which creates Graphviz files for different layouts. This are the results: http://www.thinkworx.de/graphs/Graph-sfdp.png http://www.thinkworx.de/graphs/Graph-neato.png http://www.thinkworx.de/graphs/Graph-dot.png http://www.thinkworx.de/graphs/Graph-circo.png If you like, I can explain how to make these graphs. Cheers, Torsten > Am 05.05.2020 um 16:52 schrieb Paul Dupuis via use-livecode > <use-livecode@lists.runrev.com>: > > This is NOT a "How to do this in LiveCode" question. > > I have a data set (below), produced by a LiveCode program and the data is > exported to Excel. > > I am trying to figure out: > > 1) What the "best" style of graph to visualize this data is? I thought > perhaps a "Bubble Chart" but - in Excel at least - does not seem to work for > this data. > > > 2) After determining the "best" chart style is, what charting tool (if not > Excel) can generate that style of chart for this data? > > Any tips anyone may have would be very welcome. > > The data set is below. This shows that "A" intersects with B once and C > intersects with J 4 times (as example of how to read the data). I have > replaced the actual labels (text strings for rows and columns) with the > English alphabet for simplicity. > > > > A B C D E F G H I > J K L M N O P Q R S > T U V W X Y Z > A 0 1 0 0 0 0 0 0 0 > 0 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 0 0 > B > 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 0 > C > > 0 0 0 0 0 1 0 4 1 > 0 2 0 0 1 1 0 0 1 0 > 0 1 0 1 1 > D > > > 0 0 0 1 0 0 0 1 0 > 0 0 1 0 0 0 1 0 0 0 > 0 0 1 0 > E > > > > 0 1 0 0 0 0 1 0 1 > 0 0 0 0 0 0 0 0 0 0 > 0 0 0 > F > > > > > 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 0 0 0 0 0 > 0 0 > G > > > > > > 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 0 0 0 0 1 > 0 > H > > > > > > > 0 0 0 0 0 0 0 0 1 > 0 0 0 0 0 0 0 0 0 0 > I > > > > > > > > 0 0 0 1 0 0 0 0 0 > 0 0 0 0 0 0 0 0 0 > J > > > > > > > > > 0 1 0 1 0 0 0 0 0 > 0 0 0 0 0 0 0 0 > K > > > > > > > > > > 0 0 1 0 0 0 0 0 1 > 0 0 1 1 0 0 0 > L > > > > > > > > > > > 0 0 0 2 0 0 0 0 0 > 0 0 0 0 0 0 > M > > > > > > > > > > > > 0 0 0 0 0 0 0 0 0 > 0 0 0 0 0 > N > > > > > > > > > > > > > 0 0 0 0 0 0 0 0 0 > 0 0 0 0 > O > > > > > > > > > > > > > > 1 0 0 0 1 0 0 0 0 > 1 0 0 > P > > > > > > > > > > > > > > > 0 0 1 0 1 0 0 0 0 > 1 1 > Q > > > > > > > > > > > > > > > > 0 0 0 0 0 0 0 0 0 > 0 > R > > > > > > > > > > > > > > > > > 0 0 0 0 0 0 0 0 0 > S > > > > > > > > > > > > > > > > > > 0 0 0 0 0 0 0 0 > T > > > > > > > > > > > > > > > > > > > 0 0 0 0 0 1 1 > U > > > > > > > > > > > > > > > > > > > > 0 0 0 0 0 0 > V > > > > > > > > > > > > > > > > > > > > > 0 0 0 0 0 > W > > > > > > > > > > > > > > > > > > > > > > 0 1 0 0 > X > > > > > > > > > > > > > > > > > > > > > > > 0 0 0 > Y > > > > > > > > > > > > > > > > > > > > > > > > 0 1 > Z > > > > > > > > > > > > > > > > > > > > > > > > > 0 > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
