Excel Chart

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have theromater chart Target and actual Target may vary suppose today I have target 50 and tomorrow I have target 70 after that the target value is not changing, the target value should change.
<o> </o>
Thanks,
Kashif.<o></o>

 

[kashif.special2005]

Hi Kashif Again,

Target may varry if target is 1000 then difference between range will be 100 and if target is 100 then difference between range will be 10 like wise

I think this will happen through VBA.

Please reply.

Thanks,
Kashif.

 

[JackDanIce]

You are not being very clear or precise with your requirements.

What cell ranges is your data in?
What is the name of your worksheets?
Where should output data go?

Please consider the fact you are asking a question about your own workbook to a help board where no-one can see your workbook