You can use the following formulas to find the point of intersection of two straight lines in Google Sheets: Find the X-Value…
Visualizations in Google Sheets
-
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Create and Use Variables in Google Sheets
by Tutor AspireThe easiest way to create variables that you can reference in formulas in Google Sheets is to use the Name box to…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Make a Burndown Chart in Google Sheets
by Tutor AspireA burndown chart is a chart that shows the ideal “burndown” (i.e. completion) of tasks vs. the actual burndown of tasks at…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Find the Slope of a Trendline in Google Sheets
by Tutor AspireThe slope of a trendline represents the average increase in the y-value for a one unit increase in the x-value. To find…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
Google Sheets: How to Chart Data from Multiple Sheets
by Tutor AspireYou can easily chart data from multiple sheets in Google Sheets by simply adding multiple ranges for Series in the Chart editor…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
Google Sheets: How to Change Number of Bins in Histogram
by Tutor AspireA histogram is a plot that can be used to quickly visualize the distribution of values in a dataset. This tutorial provides…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Create a Cumulative Sum Chart in Google Sheets
by Tutor AspireThis tutorial provides a step-by-step example of how to create the following cumulative sum chart in Google Sheets: Let’s jump in! Step…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Add Custom Data Labels in Google Sheets
by Tutor AspireOften you may want to add custom data labels to charts in Google Sheets. Fortunately this is easy to do using the…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
Google Sheets: How to Create a Chart and Ignore Blank Cells
by Tutor AspireOften you may want to create a chart in Google Sheets using a range of data and ignore any blank cells in…
- Google SheetsSoftware TutorialsVisualizations in Google Sheets
How to Plot an Equation in Google Sheets
by Tutor AspireOften you may want to plot an equation or a function in Google Sheets. Fortunately this is easy to do with built-in…