Protecting Chart Automatically
There is an Excel file that teaches how to perform the Protecting Chart Automatically operation.
Excel Powered Protecting Chart Automatically
This workbook demonstrates protecting chart automatically using VBA macros on a 13-row data layout.
Hope it is useful.