Expanding Excel
 

Bernie,

Thank you very much for your suggestions, and yes the
workbook you mention you would be most helpful. You can
send it to if you don't mind.

Kind regards,
Ian.

-----Original Message-----
Ian,

The easiest thing to do is
1) use a cell with a drop down of all the available
impurities.
2) use that cell as the key cell for VLOOKUP functions
(or other lookup
style functions)
3) have the VLOOKUP functions in your graph source range
as a separate
column of data

Then, when you select the impurity, the formulas should
update the graph.

I have an example workbook that I can send to you if you
have problems
figuring out my instructions.

HTH,
Bernie
MS Excel MVP

"Ian" wrote in
message
...
Apologies if this is posted in the wrong Excel section.

I own a small chemical company that analyses various
products for chemical impurities. I have a
spectrophotometer connected to my PC that analyses the
product and then exports the data into Excel and
producs a
graph. This is done via a plug-in for Excel produced by
the spectro manufacturer.

What I would like to do, if it is possible, is to have
manually entered into Excel (or an Access Db) by
myself, a
library of information on all the impurities I come
across
during my daily business. I would then like to be able
to
overlay graphs of these impurities on top of the graph
produced by the spectrophotometer software to allow for
easy and instant recognition of any impurities in the
products I'm testing. I'm thinking of maybe something
like
a drop-down box to access the information in
the "library"
and then another button that would produce the overlayed
graphs.

I'm reasonalby proficient in Access if it is easier to
hold the data there and then have Excel produce a
graph "on-the-fly" to overlay on top of the spectro
graph.
Or maybe it is easier to keep everything in Excel?

Any help would be gratefully appreciated as I just don't
know where to get started.

Many thanks,
Ian Johnson


.

Expanding Excel
 

Ian,

You'll have to wait until Monday - Turkey day, and all that....

Bernie
MS Excel MVP

"ian johnson" wrote in message
...
Bernie,

Thank you very much for your suggestions, and yes the
workbook you mention you would be most helpful. You can
send it to if you don't mind.

Kind regards,
Ian.

-----Original Message-----
Ian,

The easiest thing to do is
1) use a cell with a drop down of all the available
impurities.
2) use that cell as the key cell for VLOOKUP functions
(or other lookup
style functions)
3) have the VLOOKUP functions in your graph source range
as a separate
column of data

Then, when you select the impurity, the formulas should
update the graph.

I have an example workbook that I can send to you if you
have problems
figuring out my instructions.

HTH,
Bernie
MS Excel MVP

"Ian" wrote in
message
...
Apologies if this is posted in the wrong Excel section.

I own a small chemical company that analyses various
products for chemical impurities. I have a
spectrophotometer connected to my PC that analyses the
product and then exports the data into Excel and
producs a
graph. This is done via a plug-in for Excel produced by
the spectro manufacturer.

What I would like to do, if it is possible, is to have
manually entered into Excel (or an Access Db) by
myself, a
library of information on all the impurities I come
across
during my daily business. I would then like to be able
to
overlay graphs of these impurities on top of the graph
produced by the spectrophotometer software to allow for
easy and instant recognition of any impurities in the
products I'm testing. I'm thinking of maybe something
like
a drop-down box to access the information in
the "library"
and then another button that would produce the overlayed
graphs.

I'm reasonalby proficient in Access if it is easier to
hold the data there and then have Excel produce a
graph "on-the-fly" to overlay on top of the spectro
graph.
Or maybe it is easier to keep everything in Excel?

Any help would be gratefully appreciated as I just don't
know where to get started.

Many thanks,
Ian Johnson


.