Removing Chart Automatically
There is an Excel file that teaches how to perform the Removing Chart Automatically operation.
Excel Spreadsheet for Removing Chart Automatically
This workbook demonstrates removing chart automatically using VBA macros on a 10-row data layout.
Hope it is useful.