Currently I graph data from laboratory tests with results in the y-axis and
dates in the x-axis. I then create another series to display the compliance
level for the test over the same time period. To achieve this I need to
create another column on my data sheet to include the compliance result in
each row.

Is it possible to have the compliance figure in a single cell on my data
sheet, yet still display the compliance level on my graph together with my
data points?