How do I set up charts with a drop-down list?

  • Thread starter Thread starter Larisa
  • Start date Start date
L

Larisa

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updating sheet by choice from drop down menu 2
Filtered drop down list 2
Graph linked with combo boxes 2
Using drop down lists 2
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
Drop down list and macros? 1
DROP DOWN LIST 3
How to create Drop down list in Chart? 2

Back
Top