cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Plotting graph using excel data in Mathcad

SOLVED
Highlighted
Newbie

Plotting graph using excel data in Mathcad

Hi,

I need to plot a graph in Mathcad using data imported from excel. The calculation is an integral calculation performed in excel.

The graph will give the pattern profile of a two wheeler tyre.

The calculation sheet is attached herewith.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Plotting graph using excel data in Mathcad

Firstly you need to call your data in Mathcad, see attached. This worksheet uses a scripted component and allows data to be called from multiple sheets from Excel placing them in a nested Matrix. All you need to do is change the file path to your own directory.

Mathcad has a builkt in function wich can do this, but I maze well pass this worksheet as I have just modified it to suit you, as I thought you only had Office 2003.

What variables to you want to plot against each other?

Mike

16 REPLIES 16

Re: Plotting graph using excel data in Mathcad

Welcome to the forum.

What version of Mathcad are you using?

Mike

Re: Plotting graph using excel data in Mathcad

Thanks Mike.

Am using Mathcad 15.

--

Dhinesh

Re: Plotting graph using excel data in Mathcad

I take it you have Office 2003?

Mike

Re: Plotting graph using excel data in Mathcad

Office 2007.

Re: Plotting graph using excel data in Mathcad

Firstly you need to call your data in Mathcad, see attached. This worksheet uses a scripted component and allows data to be called from multiple sheets from Excel placing them in a nested Matrix. All you need to do is change the file path to your own directory.

Mathcad has a builkt in function wich can do this, but I maze well pass this worksheet as I have just modified it to suit you, as I thought you only had Office 2003.

What variables to you want to plot against each other?

Mike

Re: Plotting graph using excel data in Mathcad

Mike,

I want to plot graph between "r" and "Z" (column O in excel sheet).

My idea is to use to use the existing excel calculation to plot graph and gradually to build the entire calculation in Mathcad.

--

Dhinesh

Re: Plotting graph using excel data in Mathcad

Going on that basis, see attached.

I haven't produced the plots, just called the data in from Excel.

Re: Plotting graph using excel data in Mathcad

Is the graph below what your after?

Clipboard01.jpg

Mike

Re: Plotting graph using excel data in Mathcad

Thanks Mike.

I plotted graph between r & Z. Its working fine.

--

Dhinesh