Results 1 to 3 of 3
  1. #1
    kab16 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    1

    Smile Formatting Chart Axis

    Hi Everyone,

    Here is my issue. I’ve created a report to generate project specific information, to enhance this reprt I’ve added a chart where the user to see the list of tasks associated with the project on the y axis and the date each task begins and ends on the x axis (similar to a gantt). The problem Im having is that access is not reading the dates correctly but is converting them to numbers. Ideally I would like to be able to have the chart scale automatically calculated based on the specific project that was selected, allowing the x axis to only display the time span directly related to that project. Right now when I select for the scale to be auto calculated based on the data the x axis starts at 1/1/1900.

    Any suggestions??

    Oh also I have my date field set to a Date/Time data type not a number.


    Thanks in advance

  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,822
    I do have code that sets x and y axis of a chart object.

    No idea why the chart wants to start at 1/1/1900. I've never have had to graph date data.

    I analyze graph issues best when I can work with data. If you want to provide db, 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.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    have you got a sample database you can share, I don't want to have to build one myself.

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

Similar Threads

  1. Replies: 13
    Last Post: 06-10-2014, 06:19 AM
  2. Scaling a Chart Axis
    By Paul H in forum Reports
    Replies: 5
    Last Post: 10-16-2013, 01:50 PM
  3. Replies: 5
    Last Post: 01-15-2013, 01:15 PM
  4. Chart axis change with .Chartype changes
    By alangea in forum Programming
    Replies: 2
    Last Post: 05-20-2012, 12:41 PM
  5. Scatter Chart not Showing X-axis Values
    By ward0749 in forum Forms
    Replies: 4
    Last Post: 03-20-2012, 06:37 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