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