How to Graph f(x) = x³ + x⁴/4 in Excel
Question details
Create a graph of f(x) = x³ + x⁴/4 from calculated x- and y-values.

- 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.
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.
Plot the function with an Excel XY scatter chart
Use calculated y-values and a smooth-line scatter chart to graph the function.
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.
Enter =A2^3+A2^4/4 in B2, then drag its fill handle down to B26.
Select A1:B26, then choose Insert > Scatter (X, Y) > Scatter with Smooth Lines.
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.

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. 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. Calculate the function: Type =A2^3+A2^4/4 in B2 and drag the fill handle down to B26.
- 3. Create the scatter chart: Select A1:B26, then use Insert > Chart and choose an XY scatter chart with smooth lines.
- 4. Name the graph: Select the chart title and enter f(x) = x³ + x⁴/4. Save the worksheet using File > Save As.

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.




