Programming to make graph work.
I want the info in a graph to change depending on what is
typed in the "Action Cell" (this being the control cell
to get data that I want). I have a chart that looks as
followed:
DATE MIX# PSI
5/09/04 RM4000 3000
5/10/04 PC3000 2000
5/11/04 RM4000 1500
I want to have a cell I type in a Mix# and then the graph
only has data on that MIX#. So if I type RM4000 in Action
block the graph will use 1st row and 3rd. If i type
PC3000 the graph will only use 2cnd row. Can I do this
and if so please help.
Thanks Adam
|