Forum Discussion
RogerBreton
Oct 17, 2019Copper Contributor
Plotting spectral data in Access
My table has the following structure:
FieldName Value
nm380 1.23
nm390 2.67
nm400 3.87
nm410 3.45
...
nm710 1.45
nm720 2.45
nm730 0.67
Each record contains spectral data extending from 380 nanometer (nm380) to 730 nanometer (nm730). How can I plot this data in Access? I have experimented with many different approaches to no avail. I suppose I have to "massage" the data, somehow, so that they become in a form of X,Y data? So that, the "nm" column becomes X? The Value column is already in a form directly usable as Y.
I was thinking, perhaps, to extract the "number" 380, 390, 400 and so on out of the field name? So that it could become a "number" and show up on the X axis? But I have found a function to do this in the Query Editor?
- RogerBretonCopper Contributor
- tsgiannisIron Contributor
RogerBreton What exactly you mean "plotting"
If actual plotting is required...then
Either use a chart to host the data
or a Report/Form and the Line Control to make some kind of pseudo chart
- RogerBretonCopper Contributor
tsgiannis Yes, of course, I used a "Chart" control.