control buttons for chart

[Kyle Chastain]

I'm using Excel 2007;
I have a table linked to my chart. I'm filtering the table on two different
columns (produce grade and customer) to produce the charts that I want (CM%).
It works great.

I need to control the table (chart) filters from the face of the Chart and
keep the table sheet hidden. Thus, I'd like to add two buttons to the chart
face to control the filtering. How do I reference a control to a table
filter? And also I'll need to make it clear the filter (since I'm using two
independent filters) before each attempted change. Ideas anyone?

 

[Kyle Chastain]

Never Mind, I figured it out. It took a couple hours, but i got it.