Gauge chart with negative values (NPS)

[DDT123]

Hello, I'm needing a little help with a speedometer style pie chart. The range is negative 100 to positive 100, therefore a value of zero should be in the position where positive 50 would be. How would i go about modifying the chart for negative values?

 

[bobsan42]

all you need is to convert the negative values and then use the converted value to show the pointer needle.
if you use the numbers from my tables above, conversion should be something like:

=(100+U38)/10*5

U38 is the yellow cell where you will put your real value

 

[DDT123]

View attachment 108601
all you need is to convert the negative values and then use the converted value to show the pointer needle.
if you use the numbers from my tables above, conversion should be something like:

=(100+U38)/10*5

U38 is the yellow cell where you will put your real value

Thank you so much! It worked!!

 

[bobsan42]

If you want to avoid the triangular shape of the needle - set its size to 0 and use a border for the series instead of instead of fill.