Results 1 to 2 of 2
  1. #1
    Triztan is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    1

    MS Graph problem with X and Y components

    Hi all,



    does anyone know how to reproduce the graph attached (white background) in ms access?

    For each point in the graph, I would like to be able to indicate the X and Y components but
    the graph I get in access is incorrect, the y component is taken as a label not as value
    so I get the attached graph (orange background).


    Thanks for your help
    Click image for larger version. 

Name:	MSGraphXY.JPG 
Views:	7 
Size:	31.6 KB 
ID:	8344

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    Other than the y axis not crossing at 0 on x axis, the data plot looks the same. Edit the graph to specify y axis crossing. Select the x axis and set property on Scale tab - Value (Y) axis Crosses at: 0

    Not sure about getting the x axis to display the increments. Might be able to also control that on the Scale tab with the Minimum/Maximum and Major/Minor unit settings.

    If you want to provide project for analysis, I will test. 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. Bar Graph
    By scoobz1234 in forum Access
    Replies: 10
    Last Post: 04-03-2012, 12:28 PM
  2. Replies: 6
    Last Post: 02-29-2012, 03:13 AM
  3. Graph
    By Ray67 in forum Reports
    Replies: 8
    Last Post: 10-15-2011, 10:38 AM
  4. Replies: 3
    Last Post: 01-10-2011, 10:31 AM
  5. Chart/Graph
    By Tony McGuire in forum Access
    Replies: 0
    Last Post: 09-13-2009, 04:17 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