The zoom scale of the viewports comes from the scale you set when you created the viewports in your template.
The vertical scale of the profile comes from the Profile View Style, Graph tab. Change the Vertical exaggeration number to something lower. You can edit the Profile View Style before you ever run the sheets, or you can do it later and it will affect all Profile Views in the current drawing.
Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Gold Reseller
New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut