OT: How to graph a specific data set?

Paul Dupuis paul at researchware.com
Tue May 5 10:52:16 EDT 2020


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





More information about the use-livecode mailing list