Get Help

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

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

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

Showing results for

Highlighted

- Mark as New
- Bookmark
- Subscribe
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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

Top Tags