Drive multiple charts with different data from one scroll and zoom

Hi

I have a scroll and zoom chart wokiing finbe but I need to drive a second chart using a subset of data from the first chart and a second set of data. The first chart is in the form of a column chart, the second as a stacked column chart, and the third as a line in the second chart.

I know it involves creating new named ranges but I can't figure it.

I am running Excel 2010 and I have attached a sample

Any help much appreciated and an explanation of how it works will help me going forward

Thanks