Vertical exaggeration is often used if you want to discern subtle topographic features. Vertical exaggeration formula: VE = (real world units of horizontal scale) / (real world units of vertical scale).

Why do we calculate vertical exaggeration?

Vertical exaggeration (VE) is a scale that is used in raised-relief maps, plans and technical drawings (cross section perspectives), in order to emphasize vertical features, which might be too small to identify relative to the horizontal scale.

How do you do vertical exaggeration in Excel?

This should work, in Excel 2003, right-click on the Y-axis, select Format Axis... , click on the Scale tab, set the minumum and maximum to the min and max Y values for your data.