Results 1 to 4 of 4
  1. #1
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43

    Pivot Chart not Opening Properly


    I have created a couple queries to extract data from tables, from here I created Pivot Charts to show a graphical representation. It seems everytime I close out of the DB and come back the Pivot Charts are not saved, and are shown in tables again? How can I save the DB so the View when opened will always be the Pivot Charts. Secondly, I also had a question, can I use these multiple Pivot charts in a single Report to express as a Dashboard? please help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I've never incorporated pivot charts/tables/forms in any db so not familiar with all their quirks. Are you able to show even one in a report?

    Be aware MS has removed capability of creating pivot objects in Access 2013.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Quote Originally Posted by June7 View Post
    I've never incorporated pivot charts/tables/forms in any db so not familiar with all their quirks. Are you able to show even one in a report?

    Be aware MS has removed capability of creating pivot objects in Access 2013.
    I can create the Pivot Charts but that's about it. It will not allow me to save the charts, or incorporate them into Any reports. This is Strange.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 09-22-2014, 07:07 AM
  2. Replies: 9
    Last Post: 01-29-2013, 06:44 PM
  3. Replies: 0
    Last Post: 10-11-2010, 02:40 AM
  4. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  5. Query on chart not working properly!
    By Sim_ in forum Queries
    Replies: 0
    Last Post: 10-28-2009, 09:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums