Merging Chart One By One
There is an Excel file that teaches how to perform the Merging Chart One By One operation.
Excel Template for Merging Chart One By One
This workbook demonstrates merging chart one by one using VBA macros on a 5-row data layout.
Hope it is useful.