Results 1 to 2 of 2

Thread: Charting in weeks not months

  1. #1
    Join Date
    Aug 2003
    Posts
    10

    Unhappy Charting in weeks not months

    When trying to create a chart displaying weeks, I keep getting a lump sum of month(s). The input into my table is on a daily basis with several inputs a day. I made a query to group days into Week Begining (WkBeg)on a sunday. On my form I have a StartDate and EndDate for the user to input a date range, which is listed as critera for (WkBeg)query. When the chart pops up it shows the entire number of days into one column or months. When I design my chart and drag the WkBeg label to the chart axis and it turns it into months. I want to chart the weeks entered into the Form's StartDate and EndDate.

    Please Help

    Thanx in advance

  2. #2
    Join Date
    Aug 2003
    Posts
    10

    I got it

    When making the chart and setting the axis, and series, I double clicked on the WkBeg and set it to days.

Posting Permissions

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