Since using the new Excel templates in Microsoft Dynamics CRM 2016, I have found myself “playing” with various charting features in Excel. One of which was to show data as a speedometer style gauge, this proved to be slightly harder than I first expected!

I thought I would describe the process here, as once you know the correct steps this is actually quite easy!!

Note: I have combined this charting approach with an Excel template, a process I will document in another post.