Display Charts in a UserForm based on Combo Box Selection

[HangMan]

I am trying to work out how to display a chart in a UserForm, based on the user selection from a Combo Box. I have looked at the John Walkenbach solution, but have been unable to successfully adapt this to meet my needs.

I have attached a simple sample file to demonstrate what I am trying to achieve. I have a UserForm with an Image Control, a Combo Box, a Text Box and a Close Button.

I have three charts and what I want to be able to achieve is for the user to select an option from the dropdown menu and for the appropriate chart to be displayed in the Image Control and for the Text from the Combo Box to be displayed in the Text Box above the chart.

I have got as far as being able to display the 'first' chart in the Image Control, but it displays the same chart irrespective of which option I select from the Combo Box and I have no idea how to display the relevant text in the Text Box. I would like to have the first chart already displayed in the Image Control when the user launches the UserForm.

I am no expert when it comes to VBA, so if anyone is able to help, with simple step by step instructions indicating which code goes where that would be gratefully appreciated, so I can try to understand the logic.