Controlling a PivotChart using a form

[simon]

Hi,

I'm trying to make a form that displays a pivot chart which reflects
changes a user makes on a series of listboxes on the form. Whats the
best way to go about doing this?

I have 2 list boxes that will narrow the selection down (ie by
'category' and 'dates' - 'dates' being multiselection) and I have a
listbox which is to select what data is shown on the pivot chart (a
range of values at certain percentage levels).

What I want to do is have the user pick a category, a date(s) and then
a percentage amount, click a button and the pivotchart updates with
the relevant data. Then if they want to display a different range of
data, they can do so, click the button and then the pivotchart updates
accordingly.

Any suggestions on how to get the above to work?

Thanks