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.