Replicating the Plot and Constructing simular one

axg275

Active Member
Joined
Oct 5, 2004
Messages
308
Hello

I have two question for you guys.

1) I have a log log plot which is in a jpg format. I would like to get an equation for it and I dont really know what I should do?

2) I have 3 points namely

12.934 1.76
21.975 111.37
14.915 10.454

I want to make a log log plot out of them and get a straight line trendline fit with an equation. Can this be done?


Thanks for all your input.

Here is the plot of the one I would like to get an equation for.
Perm_vs_Poro%20Plot2small.jpg
[/img]
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Yes.

First, sort your data, so that it is in the order
12.934----1.76
14.915---10.454
21.975--111.37

Next, highlight your data and click on the Chart Wizard
Select XY (Scatter), and the bottom-left type of graph
Next, Finish

Now, do a right click on your vertical (y) axis, select the Scale tab, and, near the bottom, check the checkbox Logarithmic scale.
Do the same for your horizontal (x) axis.

Finally, right click on any part of the curve, choose Add Trendline..., and select the Options tab, and check the second-to-last checkbox, "Display equation on chart". Click on the Type tab, and make sure the Linear Trend line is chosen. Click OK.

If the equation is not as visible as you would like, grab it with the cursor and drag it to a more convenient and visible location.

Let us know if this solves your problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,837
Messages
5,598,379
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top