I've created a PivotChart in Access which has 4 different data fields and 1 category field. I've also created a form that displays the PivotChart as a subform. What I would like to do is program the form to change which data field lines (my PivotChart is a line chart) are visible depending on what the user wants.
I was thinking that I would use 4 check boxes, which the user can select depending on which data field line(s) they want to see. I'll call the lines A, B, C, and D. If the user wanted to see just line A, then only the "Line A" check box would be checked. If the user wanted to see all the lines, then all 4 of the check boxes would be checked, etc.
I'm pretty familiar with programming in VBA, but nothing related to PivotCharts. Any ideas or suggestions on how I can accomplish this task would be greatly appreciated.
Thanks
I was thinking that I would use 4 check boxes, which the user can select depending on which data field line(s) they want to see. I'll call the lines A, B, C, and D. If the user wanted to see just line A, then only the "Line A" check box would be checked. If the user wanted to see all the lines, then all 4 of the check boxes would be checked, etc.
I'm pretty familiar with programming in VBA, but nothing related to PivotCharts. Any ideas or suggestions on how I can accomplish this task would be greatly appreciated.
Thanks
