This sample dynamically creates a chart gallery which demonstrates some of the most commonly used Excel charting features from a single Excel 2007-2010 Open XML workbook.
First, the Category listbox is populated from the list of worksheet names. Then, for the currently selected worksheet (category), the Options listbox is populated from the
names of the individual charts on that worksheet. Finally, the SpreadsheetGear Image Rendering Utility is used to render the image by setting the ImageUrl property of the