Thread: Control graph with combo box in Excel

Hi,

Please check the attached sample data. I am trying to create the graph with two lists or combo boxes with which I can dynamically get the graph plotted.

I need to create two combo boxes; one for Region and another for the column months.

I am using Excel 2007 but I want users in Excel 2003 to be able view the data.

Regards,
Ravinder

Thank you for the reply. Yes I read those articles.

Please find the attached file where the dynamic chart is working.

I have accomplished the dynamic chart by defining two named ranges.
One for the X-Axis labels and another for the values to be plotted.

1) For Values it is:
=OFFSET(Sheet1!$C$1,1,0,Sheet1!$J$4,1)

2) For X-Axis Labels it is:
=OFFSET(Sheet1!$A$1,1,0,Sheet1!$J$4,2)

However, It still does not fully serves my purpose. I want the graph to show data only for the month which is selected not for all rows till that month.

Also the rows in $A$2:$A$21 contains merged cells due to which the Combo box has many blank rows. How can I remove those?

Thanks & Regards,
Ravinder