PortoMarco
New Member
- Joined
- Jul 10, 2014
- Messages
- 21
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:
<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
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