Creating KPI Dashboard with gauges in Excel – Visit our new Gauge Maker Add-in @ https://exceldashboardschool.com
This video helps you to create Excel Dashboards and Excel Dashboard Templates with gauges in Excel. No VBA code used to build! The model replaces the deleted needle from the picture with a moving one created from a XY chart. In this tutorial explains the geometry and trigonometry used to create a new rotating gauge needle to replace the static one. The needle positions are calculated using SIN, COS and RADIANS math functions.
Download free excel dashboard templates: https://exceldashboardschool.com/
Post time: Jan-29-2017