Keeping Track of Options Applied to create a Graph

Jun 1, 2010 at 11:08 AM

It would be really nice to have an Option that listed all the options applied for the particular graph; ie listed the layout options, everything selected in Autofill Columns, and Graph Metrics etc. Ideally this would appear seperately or as part of the graph window. If the there was an option that allow you to save this in a separate worksheet (where ever) and replay the graph - even better.

Jun 1, 2010 at 4:33 PM


Please note that if you turn on the graph legend (NodeXL, Show/Hide, Graph Elements), the legend will show the visual properties that were autofilled: edge color, width, and opacity; and vertex color, size, and opacity.  Give it a try.

Your idea for being able to replay a graph would be very useful, indeed.  In plain Excel, this kind of thing is accomplished by recording a macro, and then running the macro at will.  Ideally, NodeXL would fit right into Excel's macro world, so that you could compute graph metrics while recording a macro, for example, and then run the macro later on a different graph.  Unfortunately, Excel doesn't allow third-party software like NodeXL to integrate with its macro system, so we would have to provide our own, NodeXL-only macro recorder.  That would raise a number of problems, but it's on our list for investigation.