OT: How to graph a specific data set?

[Torsten Holmer]

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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode