How to sort the chart dynamically based on List box selection

[#1]

Hi All,

I have a list box with Regions values (North,East,south,west)

My requirement is if they click North one line chart should come and if they click east another line chart will come like wise for south and west .

But the user may select any values, so based on the selection the position of the chart to change .

I am attaching one example which is done in macro ,but i want to achieve with out macros .

Can you please help

Thanks

Rahul

[#2]

Please help..it is very imp