Chart & Visualization Issues

How to Graph f(x) = x³ + x⁴/4 in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

Create a graph of f(x) = x³ + x⁴/4 from calculated x- and y-values.

How to Graph f(x) = x³ + x⁴/4 in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to plot a polynomial function using a worksheet table and a chart.
Observed behavior
The desired result is an XY scatter chart showing the function as a smooth curve.
Before you start

Open a blank Excel worksheet and choose an x-value range and interval. For example, use values from -4 to 2 in increments of 0.25.

Solution 1Recommended

Plot the function with an Excel XY scatter chart

Use calculated y-values and a smooth-line scatter chart to graph the function.

1
Enter the x-values

In a blank worksheet, enter x in A1 and y in B1. Enter -4 in A2, type =A2+0.25 in A3, and drag A3's fill handle down to A26 to reach 2.

2
Calculate the y-values

Enter =A2^3+A2^4/4 in B2, then drag its fill handle down to B26.

3
Insert the chart

Select A1:B26, then choose Insert > Scatter (X, Y) > Scatter with Smooth Lines.

4
Label the graph

Select the chart title and enter f(x) = x³ + x⁴/4. Use the chart elements or Chart Design menu to add axis titles if needed.

Plot the function with an Excel XY scatter chart
Adjust the range: Change the starting x-value or increment and refill the formulas to show a different part of the curve. Smaller increments provide more plotted points.
Graph functions in WPS Spreadsheets

Create the same function graph in WPS Spreadsheets

Use WPS Spreadsheets to calculate the function values and plot them in an XY scatter chart with smooth lines.

  1. 1. Set up the table: Open WPS Spreadsheets and enter x in A1 and y in B1. Enter -4 in A2 and =A2+0.25 in A3, then fill A3 down to A26.
  2. 2. Calculate the function: Type =A2^3+A2^4/4 in B2 and drag the fill handle down to B26.
  3. 3. Create the scatter chart: Select A1:B26, then use Insert > Chart and choose an XY scatter chart with smooth lines.
  4. 4. Name the graph: Select the chart title and enter f(x) = x³ + x⁴/4. Save the worksheet using File > Save As.
Plot calculated function values in a scatter chartOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formulas and fill handlesCreate and edit spreadsheets for free
microsoft office alternative - wps office

Frequently Asked Questions

Why should I use an XY scatter chart instead of a line chart?

An XY scatter chart uses the numeric x-values in column A for the horizontal axis. Choose Insert > Scatter (X, Y) to plot the function against those values.

How can I make the curve look smoother?

Use a smaller x-value increment, such as 0.1 instead of 0.25, and fill both columns for the new range. Then select the expanded table for the scatter chart.

What formula calculates f(x) when x is in cell A2?

Enter =A2^3+A2^4/4 in B2. Drag the fill handle down to calculate the function for the remaining x-values.

Can I change the part of the function shown in the chart?

Yes. Change the starting value in A2 or the increment in A3, fill the x- and y-formulas down, and update the chart's data range if necessary.