I have some code that takes a bitmap of various charts across various worksheets:
Dim mysheet As Worksheet = _appExcel.Worksheets(sSheet)
Dim bitmap As System.Drawing.Bitmap = mysheet.Charts(iEntityNumber - 1).ToImage()
The problem I'm facing is being able to specify the chart I'm after if there are more that one chart on the same worksheet.
If there are ten charts, how do I reference the 6th one? (and the answer isn't always .charts(5), especially if there were originally 20 charts, and 10 have been deleted!)