Graph linked with combo boxes

S

Sasikiran

Dear,

I need assistance in plotting a graph which is linked with 3 different combo
boxes. I have data for different persons from 1st jan onwards.

I have to plot a single graph which is linked with 3 different combo boxes
having the drop down list of name, start date and end date. The graph should
reflect only the data, once the required person's data for a date range is
selected using the 3 different combo boxes.

Please assist. Also suggest if there's a better to get this.

I could able to link the graph with one combo box earlier using the below
link.

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

1-Jan 2-Jan 3-Jan 4-Jan 5-Jan ....
Steve
Mark
John
Alice
Jenny
....
...
..
 
C

ck13

I tried this for my own personal stuff and not sure if will be applicable to
you. I have a database of different countries stock indices and set a few
combo boxes so that I can select those countries that i want to see. With the
combo boxes and offset function, those selected countries data will be copied
to another location. With this, i set the source of the data for the graph
which is the new database of the selected countries.

A bit difficult to illustrate with an example here. If you want, i can email
the file to you to have a look
 
S

Sasikiran

Hello,

That will be a great help. Please email me at (e-mail address removed)

Thanks so much! :)
 

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


Top