kinetic
03-02-2011, 06:12 PM
Hi ,
I wonder if anyone familiar with Excel could help me because I can't
find anything in Tutorials or helpfiles that explains what I want to do.
I want a column of numbers to all be adjusted with a 'bias' so that
when displayed with the chart wizard, they all reference above and below
a flat line which is zero.
I know this is simply using the function feature but I can't tweak it
to do what I want. I'm >|---|< this close to working it out myself but
I'm doing my head in! :)
To draw a mental picture, imagine the numbers when drawn as a chart
show a sine wave but the sine wave goes 'uphill' or 'downhill'
I want to adjust all of the numbers so the sinewave just goes 'flatline'
left to right.
For the periodic error experts...it is a PE file but tracking the sky at
the wrong rate...too slow is uphill, too fast is downhill.
thanks in advance,
Steve
I wonder if anyone familiar with Excel could help me because I can't
find anything in Tutorials or helpfiles that explains what I want to do.
I want a column of numbers to all be adjusted with a 'bias' so that
when displayed with the chart wizard, they all reference above and below
a flat line which is zero.
I know this is simply using the function feature but I can't tweak it
to do what I want. I'm >|---|< this close to working it out myself but
I'm doing my head in! :)
To draw a mental picture, imagine the numbers when drawn as a chart
show a sine wave but the sine wave goes 'uphill' or 'downhill'
I want to adjust all of the numbers so the sinewave just goes 'flatline'
left to right.
For the periodic error experts...it is a PE file but tracking the sky at
the wrong rate...too slow is uphill, too fast is downhill.
thanks in advance,
Steve