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 image to:
spreadsheetgearimageVB.aspx?file=files/chartgallery.xlsx&worksheet=Combination&shape=Area - Column - Line
|