Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Plotting graph using excel data in Mathcad

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
05:21 AM

06-24-2011
05:21 AM

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.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:06 AM

06-24-2011
07:06 AM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
05:55 AM

06-24-2011
05:55 AM

Re: Plotting graph using excel data in Mathcad

Welcome to the forum.

What version of Mathcad are you using?

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
05:59 AM

06-24-2011
05:59 AM

Re: Plotting graph using excel data in Mathcad

Thanks Mike.

Am using Mathcad 15.

--

Dhinesh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
06:58 AM

06-24-2011
06:58 AM

Re: Plotting graph using excel data in Mathcad

I take it you have Office 2003?

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:02 AM

06-24-2011
07:02 AM

Re: Plotting graph using excel data in Mathcad

Office 2007.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:06 AM

06-24-2011
07:06 AM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:13 AM

06-24-2011
07:13 AM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:27 AM

06-24-2011
07:27 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:29 AM

06-24-2011
07:29 AM

Re: Plotting graph using excel data in Mathcad

Is the graph below what your after?

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:38 AM

06-24-2011
07:38 AM

Re: Plotting graph using excel data in Mathcad

Thanks Mike.

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

--

Dhinesh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:42 AM

06-24-2011
07:42 AM

Re: Plotting graph using excel data in Mathcad

Did you use the scripted component?

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:46 AM

06-24-2011
07:46 AM

Re: Plotting graph using excel data in Mathcad

Yes, without scripts am not able to extract the variables.

--

Dhinesh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
07:49 AM

06-24-2011
07:49 AM

Re: Plotting graph using excel data in Mathcad

I have included an alternative, which is Mathcad's built in function, READEXCEL. This will eliminate the need for a scripted component, but you will need to save your excel file in 2007 format.

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
08:02 AM

06-24-2011
08:02 AM

Re: Plotting graph using excel data in Mathcad

One last point.

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
08:03 AM

06-24-2011
08:03 AM

Re: Plotting graph using excel data in Mathcad

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
08:07 AM

06-24-2011
08:07 AM

Re: Plotting graph using excel data in Mathcad

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

06-24-2011
08:17 AM

06-24-2011
08:17 AM

Re: Plotting graph using excel data in Mathcad

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