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:

	janv-14
-1	0
-0,9	0
-0,8	0
-0,7	0
-0,6	0
-0,5	0
-0,4	0
-0,3	0
-0,2	0
-0,1	1
0	1
0,1	6
0,2	29
0,3	32
0,4	34
0,5	2
0,6	0
0,7	0
0,8	0
0,9	0
1	0

<colgroup><col span="2"></colgroup><tbody>
</tbody>

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