How to make a Dynamic bar chart

[PortoMarco]

Thanks everyone for helping me so much on this site. My excel knowledge is growing leaps and bounds every day.

I have another question.

First; here is the structure of my file.

Four tabs

1) Analysis
2) Data Group 1
3) Data Group 2
4) Inputs

In the analysis tab in cell B48 I have a dropdown box with all the months (Jan through to August)

In the input tab I have in J9:V9 a row of all the months (Jan through to Dec, J9 is blank, K9 is where Jan starts)
In the input tab from J10 to J30 I have my data range from -1 to +1 in increments of 0.1.
In the input tab from K10:V30 I have the following countif function: =COUNTIFS('Data Group 1'!$A$3:$A$261;Analysis!$B$2;'Data Group 1'!H$3:H$261;">"&$J10;'Data Group 1'!H$3:H$261;"<"&$J11) The countif returns to me all the observations from the Data Group 1 tab between (hypothetically) 0.2 and 0.3, like below:

[TABLE="width: 146"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="align: right"]janv-14[/TD]
[/TR]
[TR]
[TD="align: right"]-1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,9[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,8[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,7[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,6[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,4[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-0,1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]0,1[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]0,2[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD="align: right"]0,3[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]0,4[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD="align: right"]0,5[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]0,6[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]0,7[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]0,8[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]0,9[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

The problem is that my bar chart on the analysis tab has that range "hard coded" meaning to see Februarys data I have to manually go into the chart and select the next data range. What I would like is for the chart to automatically refresh when I select a new date from B48 in the analysis tab.

Thanks

 

[PortoMarco]

bump