Hi Friends,

I am working on an excel work book, which is consist of 10 data sheets and 10 graph sheets...! I have picked the two columns from each data sheet Column "WORK DONE" and Column "MONTHS" for each chart in chart sheet.

I have another sheet called "HOME" on this sheet i have 10 Check box list and OK button.

My Requirement:

1. When I Check the Check box1 and click on OK button, Macro should take to Chart 1
sheet.

2. When I Check the Check box1 and 2 it should show the comparative chart of Data
sheet1 and Data sheet2.

3. When I Check the Check box3,5,9 & 10 it should show the comparative chart of Data
sheet3,5,9 & 10. and so on in between all 10 check boxes..!

Can somebody please help me:

Your Help wil be more appriciable
Abamasd.