The Y axis has to be a value, not just a scale.
Do you have a set of records to chart, each with your 8 different fields?
I think the Y axis would chart each of your 8 fields and your x axis will represent each record in your found set. A calculation you define in the chart set up can label these values by referring to other data in your table such as a date or category field...
The Y axis must be the values introduced in each of the 8 fields.
The x axis must contain the labels of these 8 fields. I mean labels because the X axis never canges.
I got multiple records (patients) and 8 fields for each that take values from -10 to 120, but though ordinal fields, each field is independent from the others.
The line from the chart must link the value from these 8 values.
The calculation you mention I do not understand.
So if you see 5 sets of 8 points charted, this is from 5 records from 5 different patients in your current found set?
I attach an image to show what I mean.
Ok, there's a Delimitted values option you can use.
Use the Specify calculation with:
List ( Field A ; Field B ; Field C ; Field D ; and so forth )
For the y-axis
Specify delimitted data in the Use data from drop down.
Ultimately, you may find it better to use a related table of records to record your 8 data points instead of 8 separate fields like this.
Though I List the fields in the Y axis, the chart displays no line.
Which would be the X axis? I had the title or name of each fiield...
I can't understand your second idea about a related table. Should I insert a real table?? is that possible?
I'm sorry to bother you so much. Thanks for your help anyway!!!
For horizontal X axis, click Specify Calculation.
In the specify calculation dialog enter:
List ( 1 ; 2 ; 3 ; 4 ; 5 ; 6 ; 7 ; 8 )
If you don't want to number the points, put any labels you want in place of these numbers. If you use text, put them in quotes.
For Y axis, click Specify Calculation and enter this expression:
List ( Patients::Field 1;Patients::Field 2;Patients::Field 3;Patients::Field 4;Patients::Field 5;Patients::Field 6;Patients::Field 7;Patients::Field 8)
Note: you must have some value in every field as empty fields are omitted from the resulting list of delimitted values and this will misalign your data points and their associated labels. Put a zero in any of the 8 fields that are empty.
In the Use Data From Drop down, select "Current Record (delimitted data).
To use the related table I mentioned:
You can set up a new table linked by a Serial Number field in your current table (Patients?). You can use a portal to record the values. This, coincidentally, makes it possible to work with varying numbers of values, not just being limited to 8.
Then you can chart values by specifying the Use Data From: Related Records option to chart your data.