Connecting Charts to If Statements

[mremmenga]

I have a series of charts and I only want one of them to appear depending on a set of circumstances in the rest of the worksheet. The main sheet is intended to be a template so when a heading is selected from a drop-down menu certain charts appear. Is there any formula/macro that I could use to make different charts appear based on what is included in the dropdown?

Thanks

[Andy Pope]

See the reply to your other post in Programming.

I know you question straddles the 2 forums but there is no need to double post.