View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sasikiran Sasikiran is offline
external usenet poster
 
Posts: 104
Default 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
....
...
..