offset indirect and dynamic list help

ncarrocino

New member
Joined
Feb 6, 2013
Messages
1
Reaction score
0
Points
0
i have an expanding chart that i have set a dynamic range for each of five categories. there are also two charts right next to the chart with values for the same component but in a different category(five items all with three different sets of data). i was trying to design a way to look at the overall chart of data and on the side be able to look at the data just for one column but see all three components.

I created a dynamic drop down list that has the five items to select from. when i select it i want it to show the three corresponding categories that go with only that item. I tried and offset indirect function but i can not get it to work. Ive attached my file with only two rows.

when you select "n-feed" from the drop down the numbers 14.3 2.0 2.0 and under it 12.9 3.6 3.6. and also the date! thanks


infrontView attachment Nano Filtration for liz.xls
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
If you reformat the data as below you could pivot it easily and then use the Type as a report filter.

DateType% Ash% GA% Solids (brix with factor 0.84)
31/01/2013N_Feed14.32.02.0
31/01/2013N_Conc8.07.17.1
31/01/2013N_Perm119.30.10.1
31/01/2013N_Perm216.30.10.1
31/01/2013N_Perm313.60.10.1
01/02/2013N_Feed12.93.63.6
01/02/2013N_Conc7.18.18.1
01/02/2013N_Perm119.90.10.1
01/02/2013N_Perm216.80.10.1
01/02/2013N_Perm313.80.10.1
 
Top