I have created a form with a line plot. The numerical data for the plot is stored in rows (across fields) in a table in the database; each row corresponds to a different record. Because Access does not allow decimal field names, I named the fields consecutive integers (1 - 74). I placed the actual field names (x-axis labels) in a different table.
How do I modify the chart to replace the field names (the integers) with the actual x-axis labels? I tried editing the datasheet for the chart, but those changes are temporary because the data is replaced with data from the rowsource table. Is there a way to change the x-axis labels? I cannot change them in the query (i.e. SELECT tabel.* AS "8.00") because the labels are decimals. Thanks!