I had to make a gauge once.
I used this link for guidance:
My goal was to create various way to show the same data for the user. I no longer have the
workbook where I made it, but here is a screen shot I saved of the demo dashboard:
In the end, the user settled on a line chart (which wasn't even a part of the work I did for this demo.)
If I can help it, I never want to make a gauge again, but that's just me.
The link I gave above was all I needed to make those gauges. The trig necessary for the speedometer
arm was all I needed to get that to work. (The speedometer needle is actually the sheet itself.
The colored semicircle was a background image that I created by doing a screen shot of a pie chart I
made specifically for the image. I attached that to this reply.
Pie 9.png 41.0 KB