Graph Header and Footer automation

Jul 12, 2012 at 10:04 PM

I've searched high and low for this answer, but without luck.

Is it possible to automate the display of one cell in the workbook in the footer of the graph? I have used formulas to calculate 8 different aspects of vertices and I would like to be able to have the cell with the concatenated totals automatically update the Footer--as a legend to the graph. Right now I copy the cell content and paste it in, but if I forget, the graph and the footer don't match.

Any ideas?

Thanks a lot.

Jul 13, 2012 at 5:32 AM


There is no way to do that automatically in NodeXL.  You'll have to do a manual copy/paste.

-- Tony

Jul 13, 2012 at 2:37 PM

Thanks. I thought so, but I also thought that there was a chance that I just wasn't clever enough to figure it out. ;-)