# Gauge chart - help with changing range to non zero start

#### LB_

##### New Member
I am trying to update a gauge chart that I made in excel to show a different range (50% to 100%)

The chart is currently done on a scale of 0% to 100% with the following input calculations:

Range
Start: 0%
Section 1: 97% (input value given)
Section 2: 3% (calculation is 100% minus 97% from above)
Total: 100%

Dial to show at 81%
Start: 145.8 (calculation is (81%/100%)*180 degrees)
Width of dial: 6
End: 208.7 (calculation is 360 degrees minus start value of 145.8 minus 81%)

This chart is working properly with this range but I am now trying to update the chart to show a range of 50% to 100% only. I can't seem to make this work though. Does anyone know how to do this?

I need to build multiple charts with the same scale of 50% to 100% so looking for the theory behind how to do this so I can implement again.

Thanks!

#### Attachments

• Screenshot 2021-02-25 061501.png
3.6 KB · Views: 3

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Replies
0
Views
135
Replies
1
Views
233
Replies
2
Views
2K
Replies
4
Views
681
Replies
2
Views
522

1,127,594
Messages
5,625,695
Members
416,127
Latest member
MALEPINZON

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back