# How To Make A Spending Spreadsheet

A scatter plot is a graph that displays the relationship between variables on a single axis, usually a line. The data points are plotted within the horizontal axis and from the x-axis, the y-axis runs from left to right.

Some data, particularly those that are continuous, such as time series data, may make a scatter plot more complicated. To make the scatter plot simpler, you can break the data into a series of bar charts and then make the trend lines easier to follow.

A line that connects the start and end points can be used as a starting point for plotting trend lines. The data that is plotted will depend on how much the points change. Plotting the data with the values of the trend lines connected to the points will help indicate the direction of the trend.

## How to Make a Scatter Plot in Google Sheets

How to make a scatter plot in Google spreadsheet depends on the types of data that are plotted. For example, if a company releases information on its net income, it would be useful to plot the most recent net income and compare it to the prior year’s results. If the market values move in a linear way, they would be easier to look at.

To plot trend lines, you need to know how to fit a line through the points that are plotted. To do this, insert a new line between the x-axis and the trend line and label the points that are in the value range of the line.

Label the relevant point (the point at which the line crosses the trend line) with a number. Then, insert another line between the x-axis and the value line. Label the point at which the value line crosses the trend line with a letter, followed by the original value (or the number).

Using a log scale as well as the values that are plotted as linear trends is helpful to plot the trend line. The less data points that are plotted along the trend line, the more easily the lines can be aligned.

You can adjust the positions of the lines that connect the points on the line by setting the data scaling from a -1.0 to a +1.0. Use the color scale to show the range of values that are plotted.

When the data is continuous, the slope or y-intercept may be shown. To plot the data in a scale that is not proportional to the range of the values, use the log scale. The slope is also useful to show the percentage change of each value over time.