Chart that reconfigures with dropdown menu

**Shmulik** · 06-17-2009, 09:56 AM

The excel data set that I am trying to manipulate contains a long list of companies, dates, and profits. What I need to be able to accomplish is creating a drop down menu with the list of companies (that will be dynamically changed as companies are added or subtracted) and a chart that dynamically plots profit for each of the companies over the dates that have been given.

attached is a pdf sample of my list:
Snapshot 2009-06-17 09-54-37.pdf

THANK YOU FOR ANY HELP YOU CAN THROW MY WAY!

**DonkeyOte** · 06-17-2009, 10:24 AM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

I've moved this to Charts Forum... I appreciate it's a bit of both but there are people frequenting that forum who are Chart experts and who can handle the Code requirement (if required).

Please take the time to read the Forum Rules before posting further.

**Shmulik** · 06-17-2009, 10:30 AM

Thank you for making this correction for me; I apologize for any difficulty.
Hopping that someone in this section is going to be able to help me out with my question.

**mubashir aziz** · 06-18-2009, 12:30 AM

It is recommended to attach sample excel sheet instead of jpg or pdf file as its not attracted for forum members to create excel file and then start experiment on it ....