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.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons