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 result will not automatically look like a gauge, we will need to make some adjustments. Select the small Pie Chart icon from the Charts section.They will add to 100% so that we have a full pie. Highlight the data for the complete, incomplete and unused percentages.We will end up hiding this part of the chart by formatting it with no fill and no outline. We want our chart to look like a half circle, so 50% of our pie chart will not be used.
Incomplete – This will be the portion of our pie chart that will represent our percent incomplete and will be given by the formula =50%-Complete.Complete – This will be the portion of our pie chart that will represent our percent complete and will be given by the formula =MIN(50%,Percent Complete/2).Percent Complete – This will be a formula =Current/Fundraising Goal and represents the percentage of the goal raised to date.Fundraising Goal – This is the goal amount of the fundraising campaign.Current – This will be the current amount that’s been raised so far to date.We’ll need to set up a few fields in our spreadsheet to start. In this example we’ll chart the current amount raised against a fundraising goal. Excel doesn’t have a gauge chart option, but we can use a pie chart to create something that looks like a gauge. In a previous post I showed you How To View Actual Versus Target With A Thermometer Style Chart and in this post we’re going to look at how to display similar information in a gauge chart.
0 kommentar(er)
