NEED HELP!! Looking for a way to extract data from a growing range to create dynamic chart

Hi there,

i am hoping someone can help me.

a have a data set that of the following Headings (Project Code;Member Type; and actual(kg/m3). the project code data grows and will have duplicates(i.e. new project codes get added to the data base, there are 11 fixed member types, and the actual [kg steel/m3 concrete] are numerical values.

what i am looking to do is be able to have a drop down box which selects the project Code, which then extracts a full data list of all entries of Actual (therefore, project specific to check through each different member type and check the values/trends/results of the actual kg/m3). i am hoping to get out a dynamic chart between the info too if possible.

can someone assist me on this?? it would be greatly appreciated!

Warm Regards,
DM

Hi Ford,

Hoe gaan dit?

im based in the western cape, hope you enjoying your new life that side.

I was looking up filters for this but havent really used before, but from the method i saw on a video on youtube it didnt seem like you could used a original data set that grows as your first dependant, as a copy of the list had to be made, therefore it cant grow (grow in range of rows). so i am a bit stuck.

please see attached my smaple file, PW is 1234 to unlock keys.

We need a file with sample data and showing expected results.

Hi John,

please see attached sample data. i have one sample chart and looking for others as explained in the note in the sheet.

But basically what i am looking for is to have a drop down box (seperate for concrete and steel), that flips through the project codes , and shows a histogram of the kg/m3 and kg/m2 respectively for cncrete and steel.

secondly,a drop downbox for each project code, which gives another drop down box ability to flip through the member types member type and shows a line graph of the actual values (kg/m3 for concrete or kg/m2 for steel), which i can get an average from, min and max..

thirdly, a pie chart for each project showing the percentages of all concrete members and a seperate one for steel , for each project type.

I hope this information helps.

regards,
DM

For Concrete

in AB16

=IFERROR(INDEX(D$3:D$1000,SMALL(IF(($B$3:$B$1000=$Z$8)*($D$3:$D$1000=$Z$9),ROW($E$3:$E$1000)-ROW($E$3)+1,""),ROWS($1:1))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

THEN copy across to AC16 then down

Similar formula for other extracts