| Author |
 Topic  |
|
|
hashimkan
Pakistan
4 Posts |
 Posted - 12/07/2016 : 05:15:30 AM
|
Hello forum friends
i needed to fin a fitting for my excel data entry. it has two inputs and one output. one column contains the value of pwm provided to motor and other 9 columns have the thrust generated in grams by that motor. each thrust column has a top heading of the voltage provided. so the excel file consist of thrust values at specific pwm and voltage. i need to draw a 3d dimensional graph and get the fitting. kindly view the image.
thanks in advance
Origin Ver. 2016 and Service Release (Select Help-->About Origin):
Operating System:64-bit
 |
Edited by - hashimkan on 12/11/2016 09:58:08 AM |
|
|
Shirley_GZ
China
Posts |
Posted - 12/07/2016 : 9:44:38 PM
|
Hi
I suppose the waterfall graph would be a good solution to present your data.
http://www.originlab.com/doc/Tutorials/Waterfall
With this graph type, all thrust data(we say "Y columns") will be arranged on Z axis according to their PWM and Voltage values located at first label row. Of cause, you need first import the excel file into Origin.
I see you also talked about some "fitting", but I am not sure what you really want. Would you please give us more details?
Thanks,
Shirley
OriginLab
Originlab Technical Service Team |
Edited by - Shirley_GZ on 12/07/2016 9:47:32 PM |
 |
|
|
hashimkan
Pakistan
4 Posts |
Posted - 12/08/2016 : 02:09:33 AM
|
HI Shirley!
thanks for your quick response. i found a solution which was little hectic. i had to rearrange my excel file into 3 columns so that i could draw 3d surfaces and get the fitting out of it.
column1 column2 column3
pwm val voltage thrust
in this case my number of rows increased. first i had 26 rows but in the new format i had 26*9= 234 rows. a certain pwm was written 9 times for each voltage, and then the thrust was written in front. in this way i have solved my problem.
you can have a look at the image for more clarification.
thanks buddy.
 |
|
|
|
Shirley_GZ
China
Posts |
Posted - 12/08/2016 : 03:38:03 AM
|
Hi,
I think I have understood what you really want this time.
Actually, the sheet you post at the top post can be treated as a virtual matrix in Origin(fisrt column as X values and first label row as Y values), and then you can easily plot it as a 3D surface, such as
And, do further analysis(such as surface fitting).
In this way, you don't need do any calculation step. And furthermore, Virtual Matrix would be strongly recomended when your XY values are not evenly spaced.
To learn more about virtual matrix in Origin, please refer to this help page:
http://www.originlab.com/doc/Origin-Help/Plot-3D-Contour-VirtMat
Of cause, if needed, you can also convert your source data to XYZ data by easily using the Stack Columns tool(http://www.originlab.com/doc/Origin-Help/Wks-Stacking-Cols) in Origin, see
just as you did in Excel.
If you need any help about Origin's these features, you are welcome to send us the source data(via:tech@originlab.com), and then we will help you figure it out.
Thanks,
Shirley
Originlab Technical Service Team |
Edited by - Shirley_GZ on 12/08/2016 04:10:15 AM |
|
|
|
hashimkan
Pakistan
4 Posts |
Posted - 12/11/2016 : 09:56:01 AM
|
thanks shirley,
you have given a great answer, i have tried it and it works better.
thanks alot for your cooperation and support.
 |
|
|
| |
Topic |
|
|
|
[SOLVED] 3-d graph using excel file