Hi,
I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).
The idea is for the user to view the displayed bar charts in this subform.
While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields.
What subform properties should I be using?
Thanks,
I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).
The idea is for the user to view the displayed bar charts in this subform.
While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields.
What subform properties should I be using?
Thanks,
Comment