Hi everyone,
I created a speedometer chart using a combination of a doughnut and pie chart (in one) based off a YouTube tutorial I found here: https://www.youtube.com/watch?v=f6c93-fQlCs
The problem I'm having is that the needle only goes from 0 to 100, but I need it to go from -100 to +100 where the needle is furthest to the left for -100, in the middle (vertically) for 0, and furthest to the right for +100.
I've tried playing around with the numbers/formulas, but just can't figure it out.
Here's a sample chart that I created: https://drive.google.com/open?id=0B9Oxdy_sFHcZc3FwT0V3aC1mTkE
The number that changes is highlighted in Yellow. It works from 0 to 100, but again, I need it to go from -100 to +100. When I enter a negative number, it doesn't work properly. I don't want the gauge to extend past 180 degrees like I've seen some other speedometers.
Any help would be GREATLY appreciated! Thank you in advance!
I created a speedometer chart using a combination of a doughnut and pie chart (in one) based off a YouTube tutorial I found here: https://www.youtube.com/watch?v=f6c93-fQlCs
The problem I'm having is that the needle only goes from 0 to 100, but I need it to go from -100 to +100 where the needle is furthest to the left for -100, in the middle (vertically) for 0, and furthest to the right for +100.
I've tried playing around with the numbers/formulas, but just can't figure it out.
Here's a sample chart that I created: https://drive.google.com/open?id=0B9Oxdy_sFHcZc3FwT0V3aC1mTkE
The number that changes is highlighted in Yellow. It works from 0 to 100, but again, I need it to go from -100 to +100. When I enter a negative number, it doesn't work properly. I don't want the gauge to extend past 180 degrees like I've seen some other speedometers.
Any help would be GREATLY appreciated! Thank you in advance!
