This video demonstrates how to change/switch the chart displayed on your worksheet via a combo box drop-down list. The method explained here uses a picture object, named ranges and the INDIRECT function.
------------------------