Can any one give me some ideas on this:

I would like to export to excel only the active series on a chart.

I am using the check boxes on the legend to allow a user to switch on/off a
series.  I can successfully export all series, but I would like to only
export the series the user has selected.

TIA

Chris Davis