NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
From: Brad Morris
Date: 2014 Jan 27, 22:11 -0500
Greg
Fix the scale of the chart. Right click on the vertical axis and select min and max values.
Brad
Hi Brad,
Your sheet seems to change the scale and not actually move the Hc slope up or down
from the Hs line (?). Can I impose upon you to please take a look at my sheet and see what
you can do with it to change the value in the control cell (G20) it should step up or down in
0.1 (arc minute) steps via the buttons or a slide tool like yours. It should not change the scale.
Thanks,
~Greg
On 01/27/2014 04:49 PM, Brad Morris wrote:
Hello Greg
Here is a simple way to do what you want (I think).
Attached, please find an example (sheet 1) with instructions (sheet 2). The floating data slides up and down compared to the original data.
Hopefully its fully self explanatory. If not, I can answer questions
Brad
----------------------------------------------------------------
NavList message boards and member settings: www.fer3.com/NavList
Members may optionally receive posts by email.
To cancel email delivery, send a message to NoMail[at]fer3.com
----------------------------------------------------------------
Attached File:
(ScrollBarExampleAndInstruct.xlsx: Open and save)
Attached File:
(img/126728.slope fit.xls: Open and save or View online)