Constant values in graph

[Ceejay64]

Hey there,
I am having a bit of a problem figuring this one out. Wonder if any of you brilliant minds can help me.
I have a small db which I just built and I use it to calculate defects per million by month for six different manufacturing cells. I post charts on a monthly basis showing the results. Up until now, I have used excel, but it is much easier to input the data with access.
The problem I am having is with my results charts. I need to have bars showing previous years' averages and this year's goal along with the year-to-date numbers.
I can get a nice chart of the YTD data, but can't figure out how to add the constant cell values to the charts in addition to the calculated data. Is there a way to write them in SQL so that they will appear? I don't know much about SQL code, so don't know if this is a possibility.
Thanks in advance for any assistance you can provide!
~Ceejay64

 

[Ceejay64]

Well - I'm partway there by sidestepping around the issue. I've built a special table that holds some of the values I need to have in the charts, and an append query to add the new month's data to the table.
Now I have a new problem. The graph is not displaying the data on the X axis in the order I want.
I had to design the table's "TimePeriod" field as a text field because it wouldn't recognize "2004 Goal" or just the previous years properly. This makes it so it won't order things the way I want.
Does anyone know how I can set up the graph for a specific order on the X-axis? I know this should be simple stuff, but I've not figured it out yet. Everything I try just messes it up. Basically, it's pretty basic. Here's what I have:

SELECT qrySingleCellStats.TimePeriod, qrySingleCellStats.DPMs
FROM qrySingleCellStats;

Because it is so basic, it is actually ordering it almost right, but I need the goal bar at the end, and it's putting it before the 04 months.
I need it to order in the following manner: 2001 2002 2003 Jan-04 Feb-04 (etc) 2004YTDAvg 2004Goal
I'd also like it to show all of the months of the year whether there is data for them or not yet.
Any direction you can offer would be much appreciated!!
Thanks in advance,
~Ceejay64