I have a large group of Excel workbooks that contain my data, and I have a vb.net application for displaying certain charts from the workbooks. I also need to extract data from the workbooks and create new charts based on end user choices.
1.) For the "already-existing" charts in the workbooks, I export the charts to png files and then display them in a webbrowser control. It works fine, but I am wondering if there is a simpler/better approach.
2.) For the new charts based on end user choices, I extract the relevant data and dump it into a datagridview. I need help figuring out how to create the charts. I need an individual bar chart for each column. Sample table is below...
name x-count y-count z-count
fred 5 6 7
wilma 6 8 4
barney 23 2 1