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)
