Probably best to set up the charts in a workbook,tell us which cell(s) have the dropdown(s) you want the charts to respond to and attach that workbook here. Otherwise it will be down to you to examine the existing code and tweak it.