Forum Discussion

RogerBreton's avatar
RogerBreton
Copper Contributor
Oct 17, 2019

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?

    • tsgiannis's avatar
      tsgiannis
      Iron 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

Resources