Display charts based on text in a cell

[CraigG]

Hi

I have various charts in a worksheets, Chart1, Chart2, Chart3, etc.

In another worksheet in A1 I have a drop down menu (through data validation), for easiness let's say the drop downs are 'Chart1', 'Chart2', 'Chart3', etc.

Depending on what is selected in A1 I want the relevant chart to appear in D1
For example, if 'Chart1' is selected in A1 then in D1 I want Chart1 to appear.

Anyone any ideas how I get this to work?

Thanks for your help.

 

[FGaxha]

send me a sample excel temp and I will update and send it back.
Thera ae few steps:

 

[CraigG]

send me a sample excel temp and I will update and send it back.

Thanks for your help, unfortunately I can't upload an Excel file or use the XL2BB add-in due to permissions/settings/security. So i've uploaded pics...

 

[FGaxha]

see attached:
=VLOOKUP(G3,A2:B8,2,FALSE)

 

[CraigG]

see attached:
=VLOOKUP(G3,A2:B8,2,FALSE)

Thanks for this, unfortunately this won't work for me as every chart is different, formatted differently and based on data which is not consistent across the different charts. The charts have already been created (on another worksheet) and I was hoping I could just create an IF statement to show the relevant chart/object. (The images I uploaded were just to try to show what I'm trying to achieve and unfortunately don't show the different types of charts/data I have).