Dynamic data range in excel

[Jayadev Sarangi]

Hello, How to have a dynamic data range for a bar chart. When I select an item from a drop down the data range should move to a corresponding row for the row header selected.

Kindly help.

Regards
Jay

 

[Luke M]

Hi Jay.

One way would be with some MATCH/INDEX functions, like in the attached.

 

[Jayadev Sarangi]

Thanks Luke.....It works...

Regards
Jay