How to display chart axis dependent on another chart selection

Hi All,

I want to create chart that depends on selection on another chart

As an example think of simple chart showing population by continent.

Second chart will display figures depending on what was selected on first one

If no continent is selected  2nd chart will show same figures for continents

If we select one of continent 2nd chart will display population by conutry in selected continent

How it can be achieved?

Thanks

MCG