Similarily, you can change the colour of the two other slices as desired. Under the paint can icon change the setting to No fill and No line. Left Click on the 50% pie slice and you should see the Format Data Series change to Format Data Point.

You should see a new window pane with the heading Format Data Series on the right hand side. Change the Angle of first slice to 270 under the three vertical bar icon.

Right Click on the pie and select Format Data Series.

Delete the legend by clicking on it and pressing Delete.

Later we can also move it below the gauge.

We can change the title of the chart to something more meaningful like Fundraising Progress.

The horizontal layout of this data is kind of awkward so lets. Pie charts show a 'part to whole' relationship, and they work best with a limited number of categories. Lets build a pie chart to plot this data. Here we have data that shows market share for desktop browsers in 2016. The result will not automatically look like a gauge, we will need to make some adjustments. In this video, well look at how to create a pie chart in Excel.

Select the small Pie Chart icon from the Charts section.They will add to 100% so that we have a full pie.

Then copy it to your report and adjust overall size there without gaps around the pie. You have to make sure the plot area is selected to resize the pie, and not the pie itself (which only separates individual slices). Highlight the data for the complete, incomplete and unused percentages. you can resize the pie, the background and legend individually so that the pie fills up the entire background area.

How to make a pie chart in excel