Clear existing data before running another macro?

[Tmax95]

Hi, I am new to VBA, I currently have a drop down list and when you select a value, the macro that corresponds to that value runs. The point of this is to display a different chart when you select a value. However, when you select a new value, the previous macro that ran doesn't disappear so the charts overlap which is pointless. How can I tell excel that it needs to clear the previous chart/macro before displaying the next? Any help would be appreciated! To be clear all I did for my macro was copy an existing chart and paste it into another sheet. Maybe there is a better way than that? Here is my code:

Please Login or Register  to view this content.

[nathansav]

set the datasource to be an empty string.

[Tmax95]

set the datasource to be an empty string.

How exactly would I do that :s, I know nothing about programming.

[Tmax95]

Really need help!