Graph linked with combo boxes
 

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
....
...
..

Graph linked with combo boxes
 

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

"Sasikiran" wrote:

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
...
..
.

Graph linked with combo boxes
 

Hello,

That will be a great help. Please email me at

Thanks so much! :)


"ck13" wrote:

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

"Sasikiran" wrote:

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
...
..
.