Google Sheets allows users to add levels of certainty to charts by declaring values as estimates. In this video, Jess Stratton shows you how to create an estimate, and how it visually changes the chart.
- [Instructor] I have here a very simple sheet…that contains software and the…release order of that software.…I can turn it into a chart by selecting the data,…clicking insert chart, clicking chart types,…and choosing something as simple as a line chart…to denote the release order of this software.…I'm going to click cancel because there's…one more thing that I can add to this chart…with Google sheets.…I can add how certain I am of these values.…
Google sheets allows you to use the Boolean values…of true and false to denote certainty in your chart.…I'm going to add one more column…and I'll label it certainty.…In it I'm now going to label each one…with how certain I am.…For example, I know that these first two pieces…of software are going to be released…in this particular order.…I'm very certain so I'll call this true.…These last two could be swapped,…I'm not sure if this is the final order…so I'm going to put false.…
These are the only two values that are allowed…to be used when dealing with certainty…and estimates and Google chart data.…
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