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

Graph not showing first X value

I have a simple LIne graph. Here is the source sql:
SELECT [1999CS] AS [1999], [2000CS] AS [2000], [2001CS] AS [2001], [2002CS] AS [2002], [2003CS] AS [2003], [2004CS] AS [2004], [2005CS] AS [2005] FROM tblMembers

No matter what I do, I can't get the graph to display the 1999 field. Yes, there is data in the field. Any ideas?
0
Mach1pro
Asked:
Mach1pro
  • 6
  • 4
  • 3
1 Solution
 
nico5038Commented:
Hmm, Access sometimes acts wierd on numeric fieldnames, did you try e.g.:
SELECT [1999CS] AS [A1999], [2000CS] AS [A2000], etc. ?

Nic;o)
0
 
Mach1proAuthor Commented:
That didn't work, but what is weird is that I can reverse the field positions and what ever field I select first is the one that isn't displayed.
0
 
nico5038Commented:
Hmm, then the workaround is easy:
select "X" as Dummy, [1999CS] AS [1999], [2000CS] AS [2000], etc.

What's the interval you're using for the X-axes ?

Nic;o)
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
jefftwilleyCommented:
Did you check your Min/Max value on your Z Axis? It might be disallowing it based on the value.
J
0
 
jefftwilleyCommented:
Also...does your Graph have a ledgend? Does the value show up there?
J
0
 
Mach1proAuthor Commented:
When I added a legend, the value of the field showed up to the left of the Y axis, but the label name itself did not show up.
0
 
jefftwilleyCommented:
Did you try adding the dummy like Nico suggested?
Another thought, and I guess this could be reaching...either the line for that value is formatted to not display? or is the same color as the background of the chart. Another thought is that the plot is actually ON the Z axis?. Try stretching your graph out left to right and see if that exposes some...and like Nico suggested, check the interval on your X axis...add a count if needs be.
0
 
nico5038Commented:
Can you upload a zipped (part of) the .mdb with the troubling graph to www.ee-stuff.com and post the link here so we can have a look ?

Nic;o)
0
 
Mach1proAuthor Commented:
Here's a link to the report and table:

http://www.melandreba.com/rpt.mdb
0
 
jefftwilleyCommented:
When I took your select statement as the source of the report and created a query out of it and ran it...it returned 0 1999 records.
J
0
 
jefftwilleyCommented:
It did however return the value as ABC...which becomes the rise value for your X axis.
If I bring down the field called clients served to become your X axis, your ABC field appears along the bottom where it's supposed to be.
You're missing an output on your query for your X axis.
J
0
 
jefftwilleyCommented:
Here is a revised SQL

SELECT tblMembers.ClientsServed, tblMembers.[1999CS] AS a1999, tblMembers.[2000CS] AS a2000, tblMembers.[2001CS] AS a2001, tblMembers.[2002CS] AS a2002, tblMembers.[2003CS] AS a2003, tblMembers.[2004CS] AS a2004
FROM tblMembers;
0
 
nico5038Commented:
Basically your tabledesign is wrong and should show the years in separate rows.
You'll be limited now in the number of columns to be displayed as they are seen as different "labels"....
Best would be to have a table with:
ID
Year
CSvalue
CMvalue
That's to be used then "dynamically" to fill the different years.

Nic;o)
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 6
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now