Results 1 to 2 of 2
  1. #1
    Lynn Cohen is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    30

    Pie chart problem in Access 2010

    I’m working in Access 2010, trying to create a report with a pie chart. The pie chart is based on a query (called Count Pie) that calculates three values:
    % IS
    % NetInf
    % IS + NetInf



    I go into Create, Report Design and get a blank report in Design View. I select Chart from the Controls tab and follow the Wizard to specify the data source.

    I get a pie chart with the right title (Count Pie). I double-click on the chart to open the report Datasheet and insert the correct value names. My pie chart in Design View looks correct. It has the right title and legend, and shows three slices of the pie corresponding to the three values.

    I save the report, and go to Print Preview, where I get a pie chart that looks like a single circle; it has no legend, and doesn't show the three values.

    What am I doing wrong? Do I need to have the Access 2010 application re-installed?

    Any pointers will be greatly appreciated. Thanks, Lynn

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I have never used the chart datasheet to construct chart data source.

    I analyse chart issues best when I can work with data. If you want to provide db, follow instruction 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. How to Create Chart in Access 2010
    By braveali in forum Access
    Replies: 8
    Last Post: 04-21-2014, 11:07 AM
  2. One more problem (for now) with Access 2010
    By NISMOJim in forum Forms
    Replies: 5
    Last Post: 12-21-2013, 06:03 PM
  3. Problem Creating Excel Chart TextBoxes in Access 2010
    By JonMulder in forum Programming
    Replies: 5
    Last Post: 03-24-2013, 08:16 PM
  4. Replies: 9
    Last Post: 01-29-2013, 06:44 PM
  5. Replies: 2
    Last Post: 07-12-2010, 05:39 AM

Tags for this Thread

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