I have information that I track for 10 people and then graph it. Instead of
having graphs on different sheets or all on one sheet, I'd like to creat a
drop down list where anyone can choose a person, and then have their chart
come up, but only for the person that its selected. I do not know what
function this is considered and am having trouble finding help. If anyone
has any ideas how I go about doing this or can direct me to a helpful site I
would really appreciate it.

Thank you!

Try this:

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Larisa" wrote in message
...
I have information that I track for 10 people and then graph it. Instead
of
having graphs on different sheets or all on one sheet, I'd like to creat a
drop down list where anyone can choose a person, and then have their chart
come up, but only for the person that its selected. I do not know what
function this is considered and am having trouble finding help. If anyone
has any ideas how I go about doing this or can direct me to a helpful site
I
would really appreciate it.

Thank you!

Jon that does look like something that will help me, one question I do have
however is, does the data have to be on one sheet or can I compile the data
from different sheets?

Thank you!

"Jon Peltier" wrote:

Try this:

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Larisa" wrote in message
...
I have information that I track for 10 people and then graph it. Instead
of
having graphs on different sheets or all on one sheet, I'd like to creat a
drop down list where anyone can choose a person, and then have their chart
come up, but only for the person that its selected. I do not know what
function this is considered and am having trouble finding help. If anyone
has any ideas how I go about doing this or can direct me to a helpful site
I
would really appreciate it.

Thank you!

I've done it both ways. It's usually easier to compile it from different
sources onto one sheet (with links, so it's dynamic).

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


"Larisa" wrote in message
...
Jon that does look like something that will help me, one question I do
have
however is, does the data have to be on one sheet or can I compile the
data
from different sheets?

Thank you!

"Jon Peltier" wrote:

Try this:

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Larisa" wrote in message
...
I have information that I track for 10 people and then graph it.
Instead
of
having graphs on different sheets or all on one sheet, I'd like to
creat a
drop down list where anyone can choose a person, and then have their
chart
come up, but only for the person that its selected. I do not know what
function this is considered and am having trouble finding help. If
anyone
has any ideas how I go about doing this or can direct me to a helpful
site
I
would really appreciate it.

Thank you!

did you think in Pivot charts?

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Larisa" escreveu:

I have information that I track for 10 people and then graph it. Instead of
having graphs on different sheets or all on one sheet, I'd like to creat a
drop down list where anyone can choose a person, and then have their chart
come up, but only for the person that its selected. I do not know what
function this is considered and am having trouble finding help. If anyone
has any ideas how I go about doing this or can direct me to a helpful site I
would really appreciate it.

Thank you!