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
