Pivot chart graph disappeared after adding new record.

I created a pivot chart which was showing the graph fine with old records BUT when I added new record then run the form no chart is shown any more, I can only see the legend X any names.
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
Correction for the question:
I created a pivot chart which was showing the graph fine with old records BUT when I added new record then run the form no chart is shown any more, I can only see the legend X and Y names.
0
puppydogbuddyCommented:
Access versions prior to 2007>Try to refresh your pivot chart by using the refresh command on the menu

Access 2007> PivotChart Tools | Design | Data | Refresh Pivot
0
puppydogbuddyCommented:
You can create a subroutine behind a button that programmatically builds a pivot chart view in a form and just click the button each time you want a "new" chart.
              See this link for instructions and code
                             http://support.microsoft.com/kb/304143
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
puppydogbubby:
It did not work even when I closed the database and opened it again.
 
0
puppydogbuddyCommented:
by did not work, do you mean did not refresh?
Is your pivot chart on a form? try placing the following code behind a button on the form:

Private Sub btnRefreshChart_Click()
Me.YourChartControl.Requery
End Sub
0
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
Do you think the reason is the Trojan virus attacked the data base
0
puppydogbuddyCommented:
No, what makes you think that?  Please provide more detailed information on how you set up your chart, the query that is the data source for your chart, and the version of Access you are using.
0
puppydogbuddyCommented:
See also this link for a tutorial on how to design and build your PivotTable or PivotChart:
                             http://office.microsoft.com/en-us/access/HA010345801033.aspx
0
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
I found the problem was related to the lookup tables related  to the source record table, wen I imported copies of the table from old backed up data base the pivot worked normally I did no need to do any change in the pivot chart
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.