I'm not sure I totally get pivot charts yet but I have one that I want to change an axis scale via VBA.
On the X (horizontal category) axis, I have a range of dates. The chart is based on the entire recordset but I want the user to be able to look at a subset.
When I try a manual filter on load, the chart goes blank and asks me to add fields. When I try to change the recordsource of the subform on which the chart is based, it doesn't change.
Does anyone have experience with pivot charts in Access? TIA
ML!
On the X (horizontal category) axis, I have a range of dates. The chart is based on the entire recordset but I want the user to be able to look at a subset.
When I try a manual filter on load, the chart goes blank and asks me to add fields. When I try to change the recordsource of the subform on which the chart is based, it doesn't change.
Does anyone have experience with pivot charts in Access? TIA
ML!
