ComboBox charting

I have very complicated worksheet and id like to draw charts using combo box.
In collumn A i have week 7 dates;
In column B i have sites names;
From Column C to column L i have datas for 7 days.
I would like to draw chart by selecting site names from combo box.
DATE SITE Value1 value2 ...Value10
09/21/06 A 10 12 ...14
09/22/06 A 11 13 ...27
09/23/06 A
09/24/06 A
09/25/06 A
09/26/06 A
09/27/06 A
09/21/06 B
09/22/06 B
09/23/06 B
09/24/06 B
09/25/06 B
09/26/06 B
09/27/06 B
.
.
.
09/27/06 Y 20 15 ...53
On x Axes must be date values. In the combo Box only site names A,B,C ...Y
By selecting some site in Combo it must draw suitable 10 graps in chart
Please help me with this task.
Thanks

Originally Posted by proton

I have very complicated worksheet and id like to draw charts using combo box.
In collumn A i have week 7 dates;
In column B i have sites names;
From Column C to column L i have datas for 7 days.
I would like to draw chart by selecting site names from combo box.
DATE SITE Value1 value2 ...Value10
09/21/06 A 10 12 ...14
09/22/06 A 11 13 ...27
09/23/06 A
09/24/06 A
09/25/06 A
09/26/06 A
09/27/06 A
09/21/06 B
09/22/06 B
09/23/06 B
09/24/06 B
09/25/06 B
09/26/06 B
09/27/06 B
.
.
.
09/27/06 Y 20 15 ...53
On x Axes must be date values. In the combo Box only site names A,B,C ...Y
By selecting some site in Combo it must draw suitable 10 graps in chart
Please help me with this task.
Thanks

Two possibilities that might be worth investigating are

1) The 'back' and 'front' options for multiple charts, have an A chart, and a B chart, and send the non-selected to the Back, the Selected to the Front with code such as

Please Login or Register  to view this content.

etc.

2) Set the chart up from a 'helper' area and copy the selected figures and names into that area when triggered by the dropdown.

Hope this helps.
---