Access "graphs" :Working with/around TIme Scale axis

I'm not sure I can articulate this.
Can I get around the Time-Scale Axis settings?
I'm using a value that's mmm-yy. Works fine in queries but I can't get what I want it to do in a graph.
I'm trying to graph a 12 month period, (Apr-06 to Mar-06).
I either get a "wrap-around" affect Jan-07.... Mar-07 then Apr-06  ...
or if I mess with the scale settings (which I can't do on an on-going basis) I can't start the thng in Apr-06 and run through Mar-07, even though the query it's coming from cover that precise period.

I need a jump start...or something.

Thanks


tmccar10Asked:
Who is Participating?
 
Kelvin SparksConnect With a Mentor Commented:
OK, when you look at the chart in design, you can choose a chart type. You must choose timescale from the Advanced Tab. Once you have the data appearing properly, we can deal with any settings you need to make through code.

Kelvin
0
 
Kelvin SparksCommented:
What graph type are you using? You must use a chart type of timescale or you nd up with equidistant scales irrespective of the values. Once you've done that, you can set formating and time intervals either manually or though code


Kelvin
0
 
tmccar10Author Commented:
Thanks Kelvin

I'm using a line graph  and I get the Time Scale axis.  Im using month increments. The default for that is 1/1/07 to 12-1- 07.
As I indicated, the query is from 4-1-06 to 3-31-07 and no matter how I chang the MAX and Min setting, only the 2007 months are available for the graph.
I intend for this to run with macros and it wouldn't be practical to have to manually set the intervals.
I'm I in trouble here?
Thanks again

0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Kelvin SparksCommented:
Can you post the SQL of the query here
0
 
tmccar10Author Commented:
Kelvin, thanks
Here's the SQL for the graph

SELECT monthreport.Month, Sum(monthreport.[RS%]) AS Returns, Sum(monthreport.[SC%]) AS Scrap, Sum(monthreport.[BH%]) AS PIPP
FROM monthreport
GROUP BY monthreport.Month, monthreport.MonNum
ORDER BY monthreport.MonNum;
###################################
Month: (Format([trans date],"mmm-yy"))
MonNum: (Format([trans date],"yymm"))--I was trying to use this to keep the month sequence right

Thanks
0
 
Kelvin SparksCommented:
You are grouping bby month first, which means you can only have 12 months. Try reversing the grouping monnumfirst
0
 
tmccar10Author Commented:
I am really confused.

I tried all sorts of different combinations of groupings and orders.

It still comes out the same.

What I really don't understand is that if I run the SQL for the chart, the output is exactly what I would have expected. It appears that you first remarks about the kind of chart is important and I don't see how to work around that.
0
 
tmccar10Author Commented:
Kelvin-
I got it working. kind of...
I changed the chart type in "Custom" to "smooth line". It is the only configuration in which the dates aligned as in the query output.
I don't understand why that one format works. The only chart with a TIme scale tag was a B/W on, and that didn't line up the dates the same way.
Anyway, I got it, more-or-less.
Thanks for you interest and suggestions.

BTW, where are you ?  I don't usually get responses  that early in MY morning.

Thanks again
0
 
Kelvin SparksCommented:
I'm in New Zealand - last answer was 1.00 am in the morning
0
 
tmccar10Author Commented:
Thanks!
I appreciate the help. That's probably the longest distance from which I've gotten an EE solution.
It really is amazing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.