Results 1 to 2 of 2
  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
    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)

    Since this question was answered in the VB/VBA board in Post # <!post=212305,212305>212305<!/post>, I'm going to lock this thread.
    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
  •