How to link the combo box with the graphs in the sheets ?

[kaurmanjodh]

when I copy the combo box with the graphs to another sheets in the same workbook, the connections are lost?

 

[Jeffrey Mahoney]

Try creating a named range at the SHEET level scope for the combobox result. So, if your linked cell for your combobox is BP1, then create a named range for BP1 and make sure to change the scope to the current sheet name.

Now when you copy the combobox, the linked cell, the chart, and chart data to another sheet, the only thing you'll need to do is change the location of the named range to where the new location of the linked cell is.

It is best to copy the sheet, then move the chart and data around