Excel Dynamic chart

Dear All,

Pls help me to create a dynamic axis for attached sheet

I already put condition k26:p28 and drop down menu

all I need plot a single dynamic graph which no axis range will change while using drop down menu,

requirement :-

Data Range no of axis range
Customer Sat 5
GEC Work Share 5
AOP 4
GEC Utilization 4

FYI :- I already tried Offset and count but I did not succeed.

Pls help I already spent my last 6 hour for doing only this
KR
Rishi Saw