Are there 6 charts in each excel tab with a header or do you have all of these charts in one sheet?

If you can it would be worth uploading a dummy workbook with the structure of your data nd maybe a ppt slide with the output.