NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
From: Brad Morris
Date: 2014 Jan 28, 00:19 -0500
Gentlemen
I have taken this conversation private. Greg is being helped, I just didn't think the guts of Excel to be a NavList topic.
Brad
Greg
Fix the scale of the chart. Right click on the vertical axis and select min and max values.
Brad
On Jan 27, 2014 10:07 PM, "Greg Licfi" <cfi{at}licfi.com> wrote:
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)