Histogram viewer?

Dec 11, 2011 at 3:38 PM



In the 'Dynamic Filters' Form you have the two-handled sliders but you also have a histogram that summarizes the distribution of the data across the range via a bar chart.  Is that also a micro-soft pre-canned widget or something you also wrote?


Thanks again for your help.  This is the last question for now!



Dec 11, 2011 at 6:39 PM
Edited Dec 12, 2011 at 3:54 PM


One of the nice things about using Excel as an application platform, among several not-so-nice things, is that I was able to leverage Excel features within NodeXL and make them look like my own.  The histogram in the Dynamic Filters dialog box is an Excel chart hidden on one of the worksheets.  I set the chart properties, copy an image of the chart to the Clipboard, paste the image into the dialog box, and repeat for each histogram.

I believe the Excel chart, whose fully-qualified name is Microsoft.Office.Interop.Excel.Chart, is available for use outside Excel, but I don't know offhand how to do that.

-- Tony