-
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
-
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
-
Forum Rules
|
|