I have inserted a pivot chart into a form to display query results. I have a few questions in regards to formatting the graph.
a. When I add the value labels at the top of each series, everytime the graph refreshes they disappear and I need to add them all again to each series individually. Is there VBA code that can to stop it from removing them.
b. I am displaying a list of sales by month. I want the user to be able to filter by year and month. However, I want the graph to default to the current year each time it loads.
c. How do I change the graph using drop down lists
Any help appreciated
a. When I add the value labels at the top of each series, everytime the graph refreshes they disappear and I need to add them all again to each series individually. Is there VBA code that can to stop it from removing them.
b. I am displaying a list of sales by month. I want the user to be able to filter by year and month. However, I want the graph to default to the current year each time it loads.
c. How do I change the graph using drop down lists
Any help appreciated