Re: Programming to make graph work.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andy Pope (andy_at_andypope.info)
Date: 05/18/04 

Date: Tue, 18 May 2004 16:25:28 +0100

Hi Adam,

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

http://www.tushar-mehta.com/excel/software/autochart/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/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" <anonymous@discussions.microsoft.com> wrote 
> 
> in message
> 
>>news:e95301c43cd7$71bec760$a501280a@phx.gbl...
>>
>>>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

Relevant Pages