I'm trying to use this gauge chart on multiple worksheets:
I know, I know, gauge charts aren't the best way to visualize data, but it's what the client wants.
So I want to have multiple gauges on a dashboard and the only variable that really needs to change is the pointer percent. I'm wracking my brain trying to figure out a way to do this without having to duplicate the table with ALL of the trigonometric calculations for each gauge.
It would be easy if SHEET could be used in calculations, but alas...
Any ideas?
10 answers
