Results 1 to 2 of 2

Thread: offset indirect and dynamic list help

  1. #1

    offset indirect and dynamic list help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    infrontNano Filtration for liz.xls

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    If you reformat the data as below you could pivot it easily and then use the Type as a report filter.

    Date Type % Ash % GA % Solids (brix with factor 0.84)
    31/01/2013 N_Feed 14.3 2.0 2.0
    31/01/2013 N_Conc 8.0 7.1 7.1
    31/01/2013 N_Perm1 19.3 0.1 0.1
    31/01/2013 N_Perm2 16.3 0.1 0.1
    31/01/2013 N_Perm3 13.6 0.1 0.1
    01/02/2013 N_Feed 12.9 3.6 3.6
    01/02/2013 N_Conc 7.1 8.1 8.1
    01/02/2013 N_Perm1 19.9 0.1 0.1
    01/02/2013 N_Perm2 16.8 0.1 0.1
    01/02/2013 N_Perm3 13.8 0.1 0.1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts