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?