A gauge chart creates a speedometer-like needle to gauge where a point of data is in relation to a total. In this video, Jess Stratton shows how to create a gauge chart based off of fund raising data.
- [Instructor] I'm going to show you one…of my favorite chart types in Google Sheets.…And I'll use one of my favorite examples…to show how it can be used.…Remember our pledge and donation drive…from an earlier video?…This is a perfect way to illustrate…how the gauge chart can be used.…Like a speedometer on a car,…the gauge chart takes a maximum value…and charts a particular point…that you choose to show where it is…versus the total.…In this case, it's charting the current amount…of donations that we have…from a total amount that I'd like to raise, $4,000.…
Let's go back to our pledge sheet…and we'll build the same chart.…Here's the total pledges that we have.…Over here I've written a formula…to add up this entire column in C…and give me a total amount of how many pledges we have.…This is what I'm going to chart.…Now I have a total goal amount…and that's $4,000.…So let's have the gauge chart illustrate where we are…in relation that $4,000 total.…I'll start by selecting the cell that I want to chart.…
I'll click insert from the top menu…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.