Can a form be used to filter a chart on a report? (1 Viewer)

[gojets1721]

So I have a report with a simple bar graph. The bar pulls data from a table and shows how many complaints have been submitted on 3 different employees. I'm wondering if a form could be used to filter this data. For instance, can I have a form with a combo box containing the 3 employees' names to allow the user to select a specific employee and then see the chart with data for only that employee?

I know a form can filter a report but I don't know if it can specifically filter a chart. Is it possible and if so, any guides online?

 

[June7]

Chart RowSource could be a dynamic parameterized query (or SQL statement in the property) that references the form control. When report opens, the chart data is filtered.