I
Ian Johnson
Firstly, I apologise if I have posted this question in the
wrong Excel category.
I run a small chemical company which analyses various
products for specific impurities. I have a
spectrophotometer linked to my PC that will analyse a
given product and send the results into Excel as well as
produce a graph. This is done via a plug-in for Excel
provided by the spectro manufacturer.
What I would like to do if it is possible, is to have pre-
entered into Excel (or maybe an Access database), by
myself, as a "library" perhaps, information on known
impurities that I come across during my daily business.
From this data I would then like to overlay a graph of a
given impurity onto the graph produced by my
spectrophotometer software to allow accurate and instant
recognistion of a given impurity and its concentration.
I guess I'm looking to be able to access a known library
of information, via a dropdown box type event, and then
overlay two graphs.
I mentioned Access earlier, I'm reasonably proficient
using Access if it were easier to store data there and
then have Excel graph "on the fly" from Access. Perhaps it
would be easier to keep it all in Excel?
Any pointers would most gratefully recieved, as I really
don't know where to start.
Ian Johnson
wrong Excel category.
I run a small chemical company which analyses various
products for specific impurities. I have a
spectrophotometer linked to my PC that will analyse a
given product and send the results into Excel as well as
produce a graph. This is done via a plug-in for Excel
provided by the spectro manufacturer.
What I would like to do if it is possible, is to have pre-
entered into Excel (or maybe an Access database), by
myself, as a "library" perhaps, information on known
impurities that I come across during my daily business.
From this data I would then like to overlay a graph of a
given impurity onto the graph produced by my
spectrophotometer software to allow accurate and instant
recognistion of a given impurity and its concentration.
I guess I'm looking to be able to access a known library
of information, via a dropdown box type event, and then
overlay two graphs.
I mentioned Access earlier, I'm reasonably proficient
using Access if it were easier to store data there and
then have Excel graph "on the fly" from Access. Perhaps it
would be easier to keep it all in Excel?
Any pointers would most gratefully recieved, as I really
don't know where to start.
Ian Johnson