Hello -

I have a 'dynamic' chart where the source data comes from two drop-down
boxes -- the results of these drop-downs cause different results from a
VLookUp formula. Currently, when a user changes the drop-down boxes,
the graph changes automatically with each box. So, if the user changes
both boxes, the graph updates twice -- once for the first box, then
again with the second box.

I'd like to set this chart to update only after the user is ready, ie
pushes an 'update' button. What property needs to be turned off (or
toggled?) to prevent the graph from updating until desired? This graph
is part of a workbook with multiple other pages --- whatever is done
for the graph page should not affect the other worksheets.

Any ideas?

Thanks, Ray