Skip to main content
D
dm-31-Visitor
1-Visitor
June 24, 2011
Solved

Plotting graph using excel data in Mathcad

  • June 24, 2011
  • 2 replies
  • 14776 views

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.

Best answer by MikeArmstrong

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

2 replies

M
MikeArmstrong1-Visitor
1-Visitor
June 24, 2011

Welcome to the forum.

What version of Mathcad are you using?

Mike

D
dm-31-VisitorAuthor
1-Visitor
June 24, 2011

Thanks Mike.

Am using Mathcad 15.

--

Dhinesh

M
MikeArmstrong1-Visitor
1-Visitor
June 24, 2011

I take it you have Office 2003?

Mike

V
VladimirN24-Ruby III
24-Ruby III
June 24, 2011

Here's another solution to this problem (see attachment).

M
MikeArmstrong1-Visitor
1-Visitor
June 24, 2011

Yes,

Was that worksheet posted by Raiko? I'm sure I recognize it. The problem with this approach is that all worksheet within Excel have to numbered sequentially, but in this case they are not.

Mike

M
MikeArmstrong1-Visitor
1-Visitor
June 24, 2011

Right I have been forced to add another example now

Inputting the filename and path can be a little cumbersome and tedious, but this push button scripted component posted by Philip Oakley removes the pain of manually typing the the file path in. The button allows the user to select the require file.

Mike

Terms & ConditionsAccessibility statement