If you are still working on this problem. The controls would have to be on the form not the chart itself, then the query driving the chart would have to be modified dynamically. The chart is a single object so you can't pick out individual controls on it (i.e. by clicking on the legend).