OT: How to graph a specific data set?
Prothero-ELS
prothero at earthlearningsolutions.org
Tue May 5 11:17:06 EDT 2020
Paul,
The first question I have is: “what are you trying to communicate with your chart?” The answer to that question will point to a charting strategy.
Bill
William Prothero
https://earthlearningsolutions.org
> On May 5, 2020, at 7:53 AM, Paul Dupuis via use-livecode <use-livecode at lists.runrev.com> wrote:
>
> 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
More information about the use-livecode
mailing list