You can check in Name ranges. Here many name ranges are showing reference
error..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Mar/Thu/2012 09:02
To: excel-macros; David Grugeon
Subject: $$Excel-Macros$$ Needle Gauge Cha
Thanks for this Dave, what is the purpose of the offset function you used.
thanks
On Sat, Feb 18, 2012 at 11:27 PM, David Grugeon wrote:
> OK.
>
> first I find the number in the dial which is the greatest number less than
> or equal to the required value. I use match to find how far down it is
>
OK.
first I find the number in the dial which is the greatest number less than
or equal to the required value. I use match to find how far down it is
from J2. This number goes in P7.
Then I find out the chart value and corresponding angle for that lower
amount and these go int P8 and Q8
Next I
Wow Dave,and wow again, this is a gret solution, never mind
replying late, this is so incredible. after a while i thought it was
not possible, great mind you got over there, thumbs up seven times,
but sorry man you need to expalin the relevance of using the offset
function there and the fo
Forgot the attachment
On 16 February 2012 18:44, hilary lomotey wrote:
> Thanks Dave,
>
> thanks a lot for responding, i have attached the file to demonstrate what
> i want to achieve, basically what i want is when a stock is selected i want
> the needle to move to price of the stock, the stock
Hi Hilary
Sorry to take forever to respond. Try the attached. I have set my calcs
out rather than combine them in one massive formula so they are easier to
read and understand.
Best regards
David Grugeon
On 16 February 2012 18:44, hilary lomotey wrote:
> Thanks Dave,
>
> thanks a lot for res
Thanks Dave,
thanks a lot for responding, i have attached the file to demonstrate what i
want to achieve, basically what i want is when a stock is selected i want
the needle to move to price of the stock, the stock prices are within the
range specified in the file attached headed" prices".
On Th
Because the graduations on the dial are non linear (and not even
logarithmic) you cannot automatically calculate the values. You have to do
it by trial and error.
I have made a new column with my suggestions. You could fine tune this if
you wanted to by using more fractional numbers but for prac