This was posted before but reposting in hopes of finding a solution -

My worksheet has many rows of data with an autofilter at the top of the
column headers. The subtotal of this data feeds into a table, which feeds
into a graph. My hope is to create the autofilter dropdowns in three of the
cells on the graph/table tab that complete the autofilter function on the
data tab. This seems like something you need might need a macro for. I will
say that I can record a macro but writing a macro program is a bit over my
head.
Does anyone know if this is possible and if so, how it would be set up?

Danni,

No need to re-invent the wheel. Use a pivot chart, and the dropdowns will be available and will
filter the chart as appropriate.

HTH,
Bernie
MS Excel MVP


"Danni2004" wrote in message
...
This was posted before but reposting in hopes of finding a solution -

My worksheet has many rows of data with an autofilter at the top of the
column headers. The subtotal of this data feeds into a table, which feeds
into a graph. My hope is to create the autofilter dropdowns in three of the
cells on the graph/table tab that complete the autofilter function on the
data tab. This seems like something you need might need a macro for. I will
say that I can record a macro but writing a macro program is a bit over my
head.
Does anyone know if this is possible and if so, how it would be set up?