• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 777
  • Last Modified:

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


0
tmccar10
Asked:
tmccar10
  • 5
  • 5
1 Solution
 
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
 
Kelvin SparksCommented:
Can you post the SQL of the query here
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Kelvin SparksCommented:
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
 
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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now