Jun 7, 2009 at 3:45 AM
Edited Jun 7, 2009 at 3:47 AM
My data sets yields graphs where both the edge and vertex parameters change over time.
Marc Smith taught me how to chart evolution of edge parameters: create a (say) “Period” column in the Edges sheet; every edge set representing a graph for a given period gets a distinct value in the Period column. One can then click through
the values of Period using the Dynamic Filters control on the chart.In this way, I can visualize how edge weights change from period to period, e.g. by tying Edge Weight to Edge Width using Autofill Columns on the Visual Properties ribbon.
However, I can’t figure out an equally simple way of showing vertex properties. For a given period, I show the vertex property by tying it to Vertex Size using Autofill Columns. But the "add a period column" trick doesn't work,
since it seems that vertices have to be unique in a way that edges don’t have to be.
If I add vertices with the same names but different period values to the the Vertices column, NodeXL only shows the first ones, as one might expect.
Is this right? If so, is there some other way to show both vertix size and edge width changing as one clicks through periods? If I'm wrong, how should I do it?
I can imagine a horrid kludge to address this problem, e.g. create a new sheet with vertex properties for different periods, and then use a formula to plug in different values for Vertex Size in the Vertices sheet for different periods; the period will have
to be changed by hand before running the chart. Unfortunately, this doesn’t integrate with edge periods, and can’t be operated (as far as I can figure it) from that nifty Dynamic Filters control.
Any insights or tips greatly appreciated!
Thanks as always to Tony, Marc and the rest of the team for a super tool