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
Related articles
Dynamic data labels in a chart
My fascination for charts and vba continues (see previous posts). This post demonstrates how to highlight a group of values [โฆ]
This post describes how to add a map (background picture) to a chart. The following animated picture shows a scatter [โฆ]
This picture below shows you a column chart with pictures (flags) below each column. Watch this video to learn how [โฆ]
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 add horizontal line to chart
This tutorial shows you how to add a horizontal/vertical line to a chart. Excel allows you to combine two types of [โฆ]
How to graph a Normal Distribution
The chart above is built using the NORM.DIST function and is called Normal Distribution or Bell Curve chart. This curve is often [โฆ]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
This post describes how to add a map (background picture) to a chart. The following animated picture shows a scatter [โฆ]
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.
English
Spanish
