Moving Chart Conditionally
There is an Excel file that teaches how to perform the Moving Chart Conditionally operation.
Excel Moving Chart Conditionally
This workbook demonstrates moving chart conditionally using VBA macros on a 35-row data layout.
Hope it is useful.