Worksheets

I am working on spreadsheet created by my predecessor. It is a multiple sheet book doing live machine statistics using JPG. I have all the new pages done and VBA done. What I can't figure out is how he created a chart using half a sheet of data comprising smaller charts and cells with formula.

He has created a chart, called it chartforexport and it encompasses data as described above.

Chart type is clustered column that shows as just a blue background. He used VBA to create the JPG from this reference area. I have no idea how he did it.

Any help would be greatly appreciated.