You can either try creating a PivotChart (Data-PivotTable) which provide the
type of drop downs you're looking for. Requires a little know-how to get the
chart setup the way you want, but is not too hard.

Or, a 'fancier' route is to use dynamic charting. See:
http://peltiertech.com/Excel/Charts/Dynamics.html

Overall, based on your requirements, I'd go with the PivotChart.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tommcbrny" wrote:

Hello,

I have a sheet of data that provides customer take rates of offers over a
period of time. Customers receive offers every X minutes and either accept
or reject them. There are several customers.

I am able to create a chart that shows each customer on the chart with their
take rate over the time period. I am unable to select which customers appear
on the chart however. Is there a way to filter the series that appear on the
chart or select them, say so that I only see Customer A or Customers A, C,
and E for instance?

Thanks,
Tom