View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default How do I set up charts with a drop-down list?

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!