create a chart from query, problem with correct display

[daywalker0086]

Hallo Comunity,
I have a prblem with the creation of a chart in a report.
Attached you find the file Datenabfrage0.png which display the dta from my query..
the second file Datenabfrage.png shows the chart which should be displayed in the report. This chart was created with excel after export of the data.
So should the graph look like.
I tried to get the same thing in Access in a report, but I failed miserably.
Somehow, all values ​​are always set to 1 and form a line.


Can someone help me to pass the challenge?

[June7]

I analyse graph issues best when I can work with the data. If you want to provide file, follow instructions at bottom of my post.

[daywalker0086]

Hi June7,
thank you for your support, attached is the db.
The Query "Messwertverfolgung" contains the data.Geraetedb.zip

[ranman256]

It seems it is graphed correctly. Field2 is 6,7 for everyone in data AND graph. Same with Field3.

[daywalker0086]

Yes you are right but the graph you see is maked with excel, i want to have it in an access report, but with the build in chartmaker in access i dont get the same result.

[June7]

Would have been nice if you included the attempted chart in the database.

What table or query is that data from?

[daywalker0086]

The Data is only copy and paste from the query "messwertverfolgung" to an excelsheet.

[June7]

Odd query. Why is Messwerte table included but not joined to other tables? This results in a Cartesian relation of records. The result is two records for every Messwerte ID.

I don't read German. What is this data? Multiple similar name fields indicates a non-normalized data structure. What are Wert1, Wert2, etc and Feld1, Feld2, etc for?

[June7]

I was able to build Line and XY Scatter charts with the following RowSource:

SELECT Messwerte.ID, Messwerte.Feld1, Messwerte.Feld2, Messwerte.Feld3
FROM Messwerte
WHERE (((Messwerte.Prüfschritt)="Widerstand1"));

The ID field is the X-axis values. Don't know how useful ID as X value is. What are you trying to analyze?

[daywalker0086]

The chart you can see in my first post is a quality control chart with upper and lower control limits.
ID is the number of the teststep and not relevant.

[June7]

Need a field for the X-axis scale.

How did you produce that chart in Excel?

[daywalker0086]

I found the excel file:Messwertverfolgung.zip

[June7]

The X-axis is just a numerical sequence of 1-54, and it adjusts as rows are added/deleted in the data range. This is an option setting of the axis format. Access chart does not have this feature. A field must provide the axis values. I used the autonumber ID field. Replicating the Excel sequence requires 2 queries.

Query 1:
SELECT * FROM Messwerte WHERE (((Messwerte.Prüfschritt)="Widerstand1"));

Graph RowSource:
SELECT DCount("*","Query1","ID<=" & [ID]) AS Seq, Feld1, Feld2, Feld3 FROM Query1;

[daywalker0086]

Thank you for your Help.
i have one more problem:
Attached you can see the graph and the datatable.
The Values in the graph are not sorted in the x-axis, lik ein the table ( 1,2,3,4,5,...)
I have not foun dany option where I can select the right sorting.
Do you have a solution for it?
Thanks in advance.

[June7]

The sorting is following alpha rules because the data is text, not numeric. In alpha sort 11 comes before 2. Need placeholder 0: 01, 02, ... 11, 12.

Easiest fix is to change the Seq field to a number type.