I'm creating a pivot chart view of some data in MS Access 2010. I'm working with a large data set so every operation takes a long time.
My problem is that access automatically re-creates the pivot chart view with every change i make:
once after setting the series field,
again after setting the values field,
again after setting the categories field etc.
waiting for the chart to be recreated after every change like that is a complete waste of time and it's driving me mad.
I'd like to be able to make all the changes i want and only then hit a button and have access generate the chart, a sort of "apply" button. is it possible in any way ?