Auto Filter based on cell value / drop down list

A

Alex Delamain

I have a spreadsheet that holds quality data for multiple products
indexed on the date and time of production. Data from this is charte
so I can see chronological trends either for all products or selecte
ones using the autofilter. This currently works by placing the graph
over the data table and setting them so they dont move with the cell
beneath.

What I want to do is put the graphs on a separate sheet in the workboo
with a drop down list to select the product to chart.

How can I get the auto filter to operate based on the value selected i
the other sheet? Does this require macros or VB (neither of which I a
at all competent in!
 
F

Frank Kabel

Hi
you could alsways try to create a separate range on your data sheet
which only shows the selected items of your filter / dropdown box.
Using this range as source for your chart should do the trick (no VBA
required).

You may provide some more details (e.g. some example rows of your data
in plain text) and it should be easy to setup something for you :)
 
I

icestationzbra

i had a similar requirement. the solution that i found most useful wa
to create a pivot table, and then create a pivot chart based out o
this table. this way, what i select in pivot table gets reflected o
the graph, and vice versa
 
Top