Bar chart with a drop down box to change the X-axis

Hello,

Please see the attached workbook.

I would like to create a bar chart which is linked to a drop down box (from data validation) that allows me to choose of the 3 sets of data to show in the x axis.

So if i choose "HALF YEAR", the bar chart will have two bars (one is "jan-jul" the other is "jul-dec") with the green section data
if i choose "QUARTER YEAR", the bar chart will have four bars ("jan-mar", "apr-jun", "jul-sep", "oct-dec") with the blue section data
if i choose "INDIVIDUAL MONTHS" i have twelve bars....with the red section data.


thank you.