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

Programming to make graph work.
 

use defined names as the source of the data for you chart. Then use
formulas that define your ranges based on the value in the action cell.
Indirect or offset would probably be key elements of these dynamic formulas.

--
Regards,
Tom Ogilvy

"Adam Hicks" wrote in message
...
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

Programming to make graph work.
 

No idea how to do what you just told me too. My lack of
knowledge is hurting here. Please me alittle more
specific.

Thanks Adam
-----Original Message-----
use defined names as the source of the data for you
chart. Then use
formulas that define your ranges based on the value in
the action cell.
Indirect or offset would probably be key elements of
these dynamic formulas.

--
Regards,
Tom Ogilvy

"Adam Hicks" wrote
in message
...
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


.

Programming to make graph work.
 

Hi Adam,

Try this sites for information on the techniques Tom is describing.

http://www.tushar-mehta.com/excel/so...art/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

Cheers
Andy

--

Adam Hicks wrote:

No idea how to do what you just told me too. My lack of
knowledge is hurting here. Please me alittle more
specific.

Thanks Adam

-----Original Message-----
use defined names as the source of the data for you

chart. Then use

formulas that define your ranges based on the value in

the action cell.

Indirect or offset would probably be key elements of

these dynamic formulas.

--
Regards,
Tom Ogilvy

"Adam Hicks" wrote

in message

...

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


.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info