I am trying to programatically create xy Charts from data in an Excel
Worksheet beyond the traditional x and y data points. I want to be able to
create a data series for each item in an AutoFilter Drop down list (Filter
List?), using marker type based on another filter list, and even set the data
label from another filter list. I am having trouble wrapping my mind around
how to approach this problem. Has anybody seen an examplelike this? It
seems to be dependent on getting access to an individual Autofilters Filter
collection of items programatically. Does anyone know how to do this
programatically?