Chart displayed is selected via a dropdown menu

[Buster1320]

I have a workbook with several sheets of data and charts... I want to be able to hide all of the data sheets and individual charts so that when someone opens the workbook they only see a single sheet. I want the individual that opens the workbook to select from a dropdown menu and *poof* that chart is displated on the "front page".... I am pretty proficient with Excel, but not with VBA or the use of Macros. I found the below code, which appears todo want I want.... But it doesn't work. Is there something that I need todo in order for the code to "run"? I need to be able to send these files to others and have it work without them doing anything "special"....

The code I found...

Please Login or Register  to view this content.

Thanks!
Buster

[royUK]

Buster, please read the Forum Rules and use Code Tags in future. I will add them for you this time.

Have you amended the code to work with your sheet & chart names?

[Buster1320]

Buster, please read the Forum Rules and use Code Tags in future. I will add them for you this time.

Have you amended the code to work with your sheet & chart names?

I have read the forum rules.... Thanks for the help with wraping my code and making it appear as the rules state. I do not know anything about VBA/code so I was unsure what I really needed todo in order to follow the rules.

So, as I posted before, I am not even at the novice level with VBA...

I did amend the code to work with my sheets and charts.... That did not work, so I built a chart/sheet combo based on the VBA code that I found, and that does not work either.

I don't know if I need todo this or not, but when I compile the code, it tells me that there is an invalid use of Me on the first instance of it. Since I don't know what a valid use is, I am lost already.

Is there something that I need todo in order for the code to run?

I have attached the xls file with the sample that I built based on the code that I found...

Thanks for all of the help!
Buster

[royUK]

Your error is because you placed the worksheet code in a standard module. I'll take a look at it later

[royUK]

I've moved the code & changed it slightly

[Buster1320]

I've moved the code & changed it slightly

royUK,

It works! So what did I do wrong as I build the code into the sheet/combo chart that I have? You said I placed it in a standard module, I just used the insert module from the editor, what do I need to do?

Thanks for the help!

Buster

EDIT
--------------------------------------------
I figured it out!! I needed to view the code for the sheet and then add the VBA there.....

This is pretty powerful stuff!!! I need to figure out how todo more of this in Excel.

Again, thanks for the help!

[Andy Pope]

How about a non vba vesion?

[Buster1320]

How about a non vba vesion?

Andy,

That works also! I looked at the sheet that you attached, how did you get the drop down list to grab the chart?? I looked for functions and such and could not find the "trick"...

Thanks!
Buster

[Andy Pope]

There are 3 named ranges.

CHARTA: =Sheet1!$D$3:$L$21
CHARTB: =Sheet2!$D$3:$L$21
USECHART: =INDIRECT(Sheet3!$J$2)

The data validation displays CHARTA or CHARTB, which is used by the indirect formula.

The names reference the areas covered by the charts on sheets 1 and 2.

The thing displaying the charts is a picture object that has been linked via the formula bar to =USECHART

To create the link select any picture and in the formula bar enter =USECHART