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?

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
_______


"D_Zsol" wrote in message
...
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?

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" wrote:

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
_______


"D_Zsol" wrote in message
...
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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"D_Zsol" wrote in message
...
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" wrote:

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
_______


"D_Zsol" wrote in message
...
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?

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
wrote:

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" wrote:

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
_______


"D_Zsol" wrote in message
...
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?




Regards,

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