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