Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Chart Formatting

Status
Not open for further replies.

primagic

IS-IT--Management
Jul 24, 2008
476
GB
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

 
1. What version of Access?

2. When you say "value labels", what do you mean? Labels with static values already placed in them, or do you really mean text boxes with values relating to the current record?

3. When you say the graph refreshes, what is causing the graph to refresh?

4. In your last question, you're asking about changing the graph according to values in drop down boxes (combo boxes). What have you done in this effort? The basic way this is done is by changing the record source for the graph/chart.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top