Dynamic Chart w/ ComboBox Issue

In my attached sample file I have a set of data that I am charting dynamically using a form comboBox. Problem is that there is no way to change the font size unless I use an active x comboBox. Problem is it is not liking my offset formulas when I switch to the active x ComboBox. I've tried numerous workaround and no luck. Any help would be greatlly appreciated as I need to change the font size in the combo box for a project at work I am working on.

Originally Posted by Andy Pope

As the activex combo returns the item rather than its index position you need to use an additional formula to do that.

=OFFSET(A6,0,MATCH($K$1,$I$2:$I$4,0))

where the MATCH formula replaces the $K$1 reference.

Or you could do the match in L1 and then reference that cells value.

Worked like a charm! I was missing the match formula it seems. Never used that before.. Will have to keep this in mind for future reporting =D.