How to graph an equation
The picture above shows the following equation
plotted on an x y scatter chart. Here are the instructions on how I built this chart:
- Type -10 and -9 in cell A2:A3
- Select cell A2:A3 and click and hold on the black dot.
- Drag down until you see the number 10.
- Release the mouse button
- Select cell B2 and type: =A2^3+3*A2^2-3
- Press Enter
- Double click on dot in the lower right corner. This copies the formula to cells below as far as there are cells containing values in column A.
Insert x y scatter chart
- Go to tab "Insert" on the ribbon
- Click on scatter chart icon
- Click on the scatter chart you prefer, I chose Scatter with straight lines.
Change the x and y axis minimum and maximum value
- Right-click on x axis
- Click on "Format axis..."
- Change minimum and maximum value
- Change major units
Repeat with y axis.
Format x and y axis
- Select x axis again
- Click on Fill and Line icon
- Select "Solid Line" and pick a color.
- Repeat with y axis
Download Excel *.xlsx file
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above […]
The calendar shown in the image above highlights events based on frequency. It is made only with a few conditional […]
This Gantt chart uses a stacked bar chart to display the tasks and their corresponding date ranges. Completed days are […]
This chart is an arrow chart that has horizontal and vertical lines, positive arrows are green and negative arrows are […]
Count overlapping days in multiple date ranges
The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]
Sort based on frequency row-wise
In this article I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The second example is a […]
The POWER function calculates a number raised to a power. Excel Function Syntax POWER(number, power) Arguments number Required. The number […]
Improve your X Y Scatter Chart with custom data labels
The picture above shows a chart that has custom data labels, they are linked to specific cell values. What's on […]
How to build an interactive map in Excel
This article describes how to create a map in Excel, the map is an x y scatter chart with an […]
This picture below shows you a column chart with pictures (flags) below each column. Watch this video to learn how […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.