Learn how to create a Gauge Chart in Microsoft Excel by following this tutorial. Skip to primary navigation; ... Calculate the value and pointer by using the reference =360-(D5+D6).