if there are two y-axis, how to set one of them to x-axis?

**dogbural** · 08-30-2009, 06:01 PM

Hi all,

I have two big data, including 1) force vs. time and 2) strain vs. time. Im currently trying to plot force vs strain to find out the relationship between these factors. However, since the interval size of the time between 1) and 2) are not exactly identical, im not able to simply plot force vs strain even though the initial and the terminated time are the same. So im wondering if there is any way to do it.

Thank you for your input and help in advance.

Regards,
Minki

**dogbural** · 08-30-2009, 06:16 PM

I've attached the data i would like to solve.

Thanks

**shg** · 08-30-2009, 07:29 PM

The force column is all zeros.

Were it not, you could interpolate time vs strain to get stress vs strain.

**dogbural** · 08-30-2009, 08:05 PM

Hi Shg,

Thank you for your input.

Firstly, the force column is not all zeros.

What do you mean by interpolating time vs strain to get stress vs strain?

I mainly would like to get the relationship between force and strain, not stress vs Strain.

Regards,
Minki

**shg** · 08-30-2009, 08:08 PM

Firstly, the force column is not all zeros.

Look at column B, labeled "Force"

**dogbural** · 08-30-2009, 08:13 PM

From B80 to B197, they are non-zero values.

Thanks

**shg** · 08-30-2009, 08:20 PM

Check the file you uploaded; it only has data to row 565, and it's all zero.

**dogbural** · 08-30-2009, 08:31 PM

Hi Shg,

Please see the attached image file from the data uploaded.

Regards,

**shg** · 08-30-2009, 08:43 PM

Suggest you download the file you uploaded and look at it.

**Palmetto** · 08-31-2009, 09:00 AM

In the attachement . .
Autofiltering column-B for values greater than zero, shows B80:B197 to contains values greater than zero.

**shg** · 08-31-2009, 10:07 AM

Weird.

Add this function to the workbook.

Please Login or Register  to view this content.

In C2 and copy down,

=LINTERP(A3,$D$3:$D$337,$E$3:$E$337)

... then plot columns B & C

**dogbural** · 09-01-2009, 08:44 PM

Hi Shg,

It works very well..

Thank you very much..

Regards,
Minki

if there are two y-axis, how to set one of them to x-axis?

LinkBack

Thread Tools

Rate This Thread

Display

if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Re: if there are two y-axis, how to set one of them to x-axis?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions