Chart with dropdown list

[Arup Dutta Chowdhury]

I have an excel file where there are name and month wise sale figure is given. I want to create a drop down list where so that when I select the name of the people, chart will automatically get changed.

 

[Chihiro]

What chart?

Personally, I'd just flatten out the table and use pivot table with slicers.

 

[XLPadawan]

=OFFSET(E1,(MATCH(G7,E2:E4,0)),(MATCH(G8,F1:H1,0)),1,1)

 

[Arup Dutta Chowdhury]

Hi Chihiro I do not want to use pivot table slicer. Is there any other way to do the chart.

 

[Chihiro]

Sure there is. But I've got no idea what sort of chart you are trying to do.

After all, I'm not a mind reader.