Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access97 Charting (Access97)

    Hi All,

    I am trying to chart to separate fields. One contains a formatted "Short Date," and the other contains formatted " 3:06:00 AM," time.

    12/01/02 2:06:00 AM
    12/02/02 2:56:00 AM
    12/03/02 3:45:00 AM
    12/04/02 2:39:00 AM
    12/05/02 2:51:00 AM

    When I try to chart these the Excel (bar graph) charting function places the date and time on the same line. It doesn't place the date on an axis and the times on the other axis.

    I did test:

    12/01/02 10
    12/02/02 35
    12/03/02 4
    12/04/02 25
    12/05/02 18

    and it placed the dates on one axis and the widget numbers on the other axis.

    Any ideas on how I can chart dates with corresponding times?

    Thanks,

    James

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access97 Charting (Access97)

    That is annoying how poorly Excel reads your mind at times! To answer your question, I had to explicitly specify the Series data in the second step of the chart wizard. Just click on the Series tab, remove the second series, and redefine the first series:
    Attached Images Attached Images
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 Charting (Access97)

    Thanks Sam. Your answer worked great.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access97 Charting (Access97)

    This post is a duplicate of <!post=Message 212254,212254>Message 212254<!/post> in the Access board. Since charts aren't really Access objects, I'm going to lock the Access thread and post a link to this one. In the future, please indicate that you have cross posted and avoid cross posting unless you have not received an answer to the original post within a reasonable length of time.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •