How to Graph a Function in Google Sheets

Transforming a mathematical function into a visual graph doesn't have to mean reaching for specialized software. You can create clear, accurate, and customizable graphs for linear, quadratic, and even trigonometric functions right inside Google Sheets. This article walks you through the entire process, from setting up your data to customizing your final chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Graph Functions in Google Sheets?

While not a dedicated graphing calculator, Google Sheets is an incredibly versatile tool for visualizing mathematical functions. It's perfect for students, teachers, analysts, and anyone looking to understand the relationship between variables visually.

Plotting a function helps you:

• See the shape of the equation: Is it a straight line, a gentle curve, or a repeating wave? A graph instantly shows you the nature of the function.
• Identify key points: Easily spot intercepts, maximums, minimums, and points of inflection.
• Compare different functions: Plot multiple functions on the same chart to compare their behavior.
• Present your findings: A clean chart is much easier to share and explain than a table of raw numbers.

Best of all, you already have access to it. Let's get started.

Step 1: Set Up Your (x) and (y) Data Columns

Every function graph plots the relationship between an independent variable (typically x) and a dependent variable (y). The value of y depends on the value of x according to your function's formula. To create a graph in Google Sheets, you first need to generate a table of these x and y values.

Create Your 'x' Column

The 'x' column will contain the series of points you want to plot along the horizontal axis. You get to decide the range (e.g., from -10 to +10) and the increment (e.g., steps of 1, 0.5, or 0.1).

Pro Tip: For curved functions, using smaller increments (more data points) will produce a smoother-looking graph.

Here’s the easiest way to create your series of x-values:

1. Click on cell A1 and type a header, like "x".
2. In cell A2, enter your starting value (e.g., -10).
3. In cell A3, enter the next value in your sequence (e.g., -9).
4. Select both cells A2 and A3. You'll see a small blue square in the bottom-right corner of your selection. This is the "fill handle."
5. Click and drag the fill handle down. Google Sheets will intelligently continue the sequence for you. Drag it far enough to reach your desired end value (e.g., +10).

You now have your independent variable column ready!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Create Your 'y' Column using a Formula

The 'y' column is where the magic happens. Here, you'll translate your mathematical function into a Google Sheets formula. This formula will calculate the corresponding y-value for each x-value you just created.

1. Click on cell B1 and type a header that represents your function, like "y = 2x + 5" or just "y".
2. In cell B2, type the equals sign (=) to start your formula.
3. Write your function, but instead of "x," you’ll reference the cell containing your first x-value (A2).

For example, to graph the function y = 2x + 5, your formula in cell B2 would be:

=2*A2+5

Use standard operators for your formulas:

• Addition: +
• Subtraction: -
• Multiplication: *
• Division: /
• Exponents (to the power of): ^

Once you’ve entered the formula in B2 and pressed Enter, it will calculate the result for the x-value in A2. To apply this to all your other x-values, simply click on cell B2 and drag the fill handle down to the bottom of your data. Google Sheets automatically adjusts the formula for each row (A3, A4, etc.).

Example 1: Graphing a Linear Function (y = 2x - 1)

Let's walk through a complete example with a simple straight line. Our goal is to graph y = 2x - 1 from x = -5 to x = 5.

1. Prepare the Data

• In cell A1, type x. In cell B1, type y = 2x - 1.
• In cell A2, type -5. In cell A3, type -4.
• Select A2 and A3, then drag the fill handle down until you reach the value 5 in row 12.
• In cell B2, enter the formula for our function:

=2*A2-1

• Press Enter. The cell should display the result of the formula.
• Click cell B2 and drag its fill handle down to row 12. You now have a complete table of x and y values.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Insert the Chart

• Select your entire data range, including the headers (A1:B12).
• Go to the menu and click Insert > Chart.
• Google Sheets will automatically suggest a chart. It often defaults to a Line Chart, which works well. However, a Scatter chart is generally the best choice for graphing mathematical functions, as it plots the (x, y) coordinates precisely.
• In the Chart editor that appears on the right, under the Setup tab, change the Chart type to Scatter chart.

You've just graphed your first function! It should be a perfectly straight line passing through your calculated points.

Example 2: Graphing a Quadratic Function (y = x² + 2x - 3)

Now let's try something with a curve: a parabola. The steps are identical, but our formula will be different.

1. Prepare the Data

• Let's plot this from x = -10 to x = 10 with an increment of 1. For a smoother curve, you could choose an increment of 0.5.
• Use the same method as before to create an x column from -10 to 10.
• In the y column (cell B2), enter the formula for the quadratic function. Remember to use ^ for the exponent:

=A2^2+2*A2-3

• Press Enter and drag the fill handle down to apply the formula to all your x-values.

2. Insert the Chart

• Select your data range (A1:B22, for example).
• Click Insert > Chart.
• Change the Chart Type to Scatter chart if it isn’t already selected.

You should instantly see the characteristic "U" shape of a parabola. Now is a good time to make the curve smoother.

How to Add a Polynomial Trendline for a Smoother Curve

Rather than connecting the dots with straight lines, you can ask Sheets to fit a smooth polynomial curve to your data.

• In the Chart editor, go to the Customize tab.
• Expand the Series section.
• Check the box for Trendline.
• Change the Type to Polynomial.
• Choose a Polynomial Degree of 2 (since this is a quadratic function).

This will overlay a perfectly smooth parabola on your data points, making the graph look much more professional.

Example 3: Graphing a Sine Function (y = sin(x))

Graphing trigonometric functions like sine, cosine, or tangent is just as easy, but with one crucial detail: Google Sheets' trig functions operate in radians, not degrees.

If you set up your x-values as 0, 1, 2, 3..., you will be inputting 0, 1, 2, and 3 radians into the SIN() function. This is perfectly fine! A full sine wave cycle happens over 2π radians (about 6.28). Let's graph two full cycles from 0 to 4π.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Prepare the Data

• Set up your x column. Start with 0 in A2. For the increment, let's use about 0.2. So, in A3, enter 0.2.
• Drag the fill handle down until you get to about 12.6 (which is roughly 4π).
• In B2, enter the sine formula:

=SIN(A2)

• Press Enter and drag the formula down.

2. Insert and Customize the Chart

• Select your data and insert a Scatter chart.
• Because we have so many closely spaced points, the dots will already look like a smooth line. If you prefer a solid line instead of dots, you can adjust this.
• In the Chart editor > Customize > Series tab, you can change the Point size to 0px (or select None) and choose a solid line from the Line dash type dropdown to get a clean-looking wave.

You’ll see two complete, graceful sine waves representing your function.

Customizing Your Graph for a Professional Look

The default Google Sheets chart is functional, but you can make it much clearer and more professional with a few tweaks in the Customize tab of the Chart editor. Here are a few essential adjustments:

• Chart & axis titles: Give your chart a descriptive title. Label your Horizontal (x) and Vertical (y) axes so everyone knows what they're looking at.
• Series Formatting: Change the color of your line or points, adjust the line thickness, or change the point shape to match your presentation style.
• Gridlines & ticks: Adjust the spacing of the gridlines on both axes to make your chart easier to read. You can add minor gridlines for more detail.
• Legend: If you are plotting multiple functions on one graph, the legend is essential. You can change its position (top, bottom, right) here.

Final Thoughts

Graphing a function in Google Sheets comes down to a simple three-step process: generate a column of x-values, use a formula to calculate the corresponding y-values, and then insert a chart - preferably a Scatter chart - to visualize the results. With a bit of customization, you can create reports that clearly communicate the behavior of any mathematical function.

Putting these reports together is straightforward, but it can become repetitive if telling stories with data is a big part of your job. At Graphed, we’ve automated this entire process. Instead of manually setting up columns, writing formulas, and customizing charts, you can simply ask your questions in plain English - like "graph y = x² from -10 to 10" - and get a perfect visualization in seconds. We connect directly to your most important data sources, so you get live, interactive dashboards without any of the manual setup.