Link Combo Box to Autofilter argument
 

First, my thanks to Jon Peltier for his helpful advice on a previou
issue.

I have successfully charted a large amount of game result data in a
x-y plot, and I can filter the series data in the chart usin
autofilter on the source data sheet; e.g., game1, run2, move4, RedTeam
etc. This provides a very neat way to look at locations of events i
the game space. Now, I would like to make it easy for th
user/reviewer of this analysis to select the criteria for the differen
series by choosing from drop down combo boxes or by selecting multipl
criteria <OR with check boxes. I have tried to put thes
combo/checkbox features on the chart page directly, but need some VB
examples to establish the selection criteria.

As a shortcut, is there a way to link a form's combo box on a char
page to the selection criteria of a column in an autofilter list?
have not been able to find the VBA code that is evidently driving th
autofilter function. I could relocate the chart to the data page an
hide unneeded columns and then size the chart area to hide all but th
autofilter drop-downs, but that lacks elegance and may expose th
source data to damage if the focus shifts to the underlying dat
sheet.

Finally, I have crafted some series to serve as highlights for the x-
plots. For example one series supplies a few circles on the x-y plo
to focus attention on an especially significant grouping. I'd like t
be able to have these special series selected for display based on th
same autofilter criteria I am attempting to capture as describe
above.

Thanks for your insights or direction to other sources to investigate.

Best regards, Joh

--
Message posted from http://www.ExcelForum.com