?
Solved

Pivot chart graph disappeared after adding new record.

Posted on 2010-01-12
10
Medium Priority
?
546 Views
Last Modified: 2012-05-08
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.
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292485
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292664
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292815
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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292820
puppydogbubby:
It did not work even when I closed the database and opened it again.
 
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26292954
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
 

Author Comment

by:Dr.Abdulwahab Al-anesi
ID: 26292960
Do you think the reason is the Trojan virus attacked the data base
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26293147
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 26293214
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
 

Accepted Solution

by:
Dr.Abdulwahab Al-anesi earned 0 total points
ID: 26295137
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

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question