Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63

    x and y axis of xy-chartes

    I have a one XY- chart in one report that in row source:

    "TRANSFORM Sum(Dispes.Move) AS SMove SELECT Dispes.Date FROM Dispes GROUP BY Dispes.Date PIVOT Dispes.Depth;"



    in this way y-axis assigns Move field and X-axis assigns Depth field. But I want to have a a chart Grouped by Date And PIVOT with Depth fieldes, but with X-axis assigns Move field and Y-axis assigns Depth field .how I does this?

  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,822
    Provide sample of source data.
    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
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    I want to have a a chart Grouped by installevel And with RE fieldes, but with X-axis assigns SettlBese field and Y-axis assigns installevel field in attached report.F:\IS.rar

  4. #4
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    In attached report I want to have a a chart Grouped by installevel And with RE fieldes, but with X-axis assigns SettlBese field and Y-axis assigns installevel field and with legend by re field.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    This Crosstab will get data in that arrangement but problem is there are null fields in each series. This interrupts the line connecting points.
    TRANSFORM First(Table1.INSTALLEVEL) AS FirstOfINSTALLEVEL
    SELECT Table1.SETTLBASE, Table1.INC
    FROM Table1
    GROUP BY Table1.SETTLBASE, Table1.INC
    PIVOT Format([RE],"Short Date");

    Also, in your original report the graph RowSource does not include the INC field so don't see how data can synchronize with the report's RecordSource. But using a pivot query as graph RowSource is new to me. My data structure is such that I have to use UNION query to rearrange then I SELECT from the UNION query with WHERE clause to filter. Not using the Master/Child properties to synchronize.
    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.

  6. #6
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    i want to group my data with INSTALLLEVEL and RE fieldes,not SETTELBASE field.the SETTELBASE is value.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    X-axis assigns SettlBese field and Y-axis assigns installevel field and with legend by re field
    My suggestion results in this arrangement. I know the SQL looks wrong but it worked. Just don't know how to deal with the nulls.
    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.

  8. #8
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    in your sugesstion data is grouped by SettellBase,but i want to grouped only by INSTALLEVEL and RE fieldes.the chart that i want similar to my sended report to you only should be rotated 90degree.

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Then guess I don't understand what you are looking for. I built graph on my suggested query and the Settlbase field generates the x axis and Installevel field is the y axis. Two series are plotted - one for each date.
    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.

  10. #10
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    i looking for attached chart.your sugesstion is defrent from my wanted chart.

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    How did you produce that graph - Excel? The graphing utility in Excel is more versatile than in Access, even though supposed to be the same engine.
    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.

  12. #12
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    only i rotated my chart in pdf file.in access chartes don't have any rotation option.

  13. #13
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Here, check out my suggestion in the attached. I will remove the file after you respond or in a few days.

    EDIT: Purpose served, file removed.
    Last edited by June7; 08-06-2011 at 11:09 AM.
    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.

  14. #14
    afshin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    63
    sendede freport file is't what i want.

  15. #15
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I don't quite understand your last post. You were able to open the file? I just noticed your profile says Access 2007 but the file you offered seemed to be Access 2010.

    Sorry if the suggestion still doesn't meet your needs. To me, it looks like the example you provided. It is the best I can do within Access.
    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.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Changing field data into labels on the y-axis
    By slaterino in forum Access
    Replies: 1
    Last Post: 09-28-2010, 03:15 PM
  2. Adjusting the axis of a graph using VBA
    By Sniper-BoOyA- in forum Programming
    Replies: 0
    Last Post: 08-04-2010, 06:41 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