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