I would like to know if there is a way to either select data from clicking on the pivot table bar or for the bar to be highlighted when the data record is viewed.
I have a form with a sub form and a pivot chart bar graph displayed on it. They both get their data from the same query. The information on the query is updated by inputs on the form. The sub form displays information about the product in single form view and the bar graph shows usage rate by type and days.
I would prefer that when you click on a bar in the pivot chart that the corresponding record would display in the sub form.
If that is not possible, I would like the corresponding bar in the graph to highlight when a record is selected.
I am not super in VBA but do have enough knowledge to anger myself and then go Woo hoo when it works.