Putting Charts into some kind of Drop Down Menu

[D_Zsol]

Currently, in Microsoft Excel, I have developed a workbook that contains many
of the petroleum derivatives that going into the various chemicals that we
purchase for our organization. The main focus of this workbook is the graphs
that I have developed which show the price trends of these given derivatives.
I would like to a master sheet in this workbook with a dropdown menu that
could reference all of the supporting worksheets in the work book to that my
director can simply open the workbook, go to the mastersheet with a drop down
menu, pick the chemical name he wants to see via that menu, and have the
graph and data appear on that sheet. Is this possible?

 

[Jon Peltier]

You can control where the data comes from that is plotted:
http://peltiertech.com/Excel/Charts/ChartByControl.html

You could instead provide a list of hyperlinks to each sheet, with a
hyperlink on each back to the contents page.

- Jon

 

[D_Zsol]

Thanks, but that doesnt help at all, i want to have all of my sheets and
master sheet within one book. Using the hyperlink feature requires that the
master sheet containing the hyperlinks be in a seperate workbook, any other
ideas?

 

[Jon Peltier]

Using the hyperlink feature requires that the

master sheet containing the hyperlinks be in a seperate workbook

Where did you hear this? Go to Insert menu > Hyperlink, in the dialog choose
Place in this document, then define the place.

- Jon

 

[Tushar Mehta]

One can link to any cell or any named range in any sheet in any
workbook, including the workbook containing the link. See the
introductory section of

Hyperlinks in Excel
http://www.tushar-mehta.com/excel/tips/hyperlinks.html

On Tue, 7 Oct 2008 11:00:03 -0700, D_Zsol

Thanks, but that doesnt help at all, i want to have all of my sheets
and
master sheet within one book. Using the hyperlink feature requires
that the
master sheet containing the hyperlinks be in a seperate workbook, any
other
ideas?

You can control where the data comes from that is plotted:
http://peltiertech.com/Excel/Charts/ChartByControl.html

You could instead provide a list of hyperlinks to each sheet, with a
hyperlink on each back to the contents page.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products