hi all...
i have some test results with me.
i tested one job for vibration testing at different 8 points.
every time i attached an accelerometer to one point and took a frequency sweep of 10- 80 Hz.
i got values of acceleration at 510 instances for 10- 80 hz.
I want graph of 'g' level Vs frequency.
but excel is giving me graph of 'g' level Vs instances... ie it is plotting 1-510 on x axis instead of 10-80...
eg:my values are
| FREQUENCY | point 1 |
| X Unit(Hz) | Y Unit(gn) |
| X Value | Y Value(Mag) |
| 10 | 1.001883583 |
| 10.04077648 | 0.99476612 |
| 10.08171924 | 0.995766799 |
| 10.12282894 | 0.995167559 |
| 10.16410628 | 0.995450647 |
| 10.20555193 | 0.995657396 |
| 10.24716658 | 0.994743851 |
| 10.28895092 | 0.994969174 |
| 10.33090564 | 0.995580278 |
| 10.37303144 | 0.996990565 |
| 10.41532902 | 0.996006418 |
| 10.45779906 | 0.996843332 |
| 10.50044229 | 0.997854805 |
| 10.5432594 | 0.998303798 |
| 10.5862511 | 0.998081003 |
| 10.62941811 | 0.99851113 |
| 10.67276114 | 0.99745959 |
please help me..
Good Answers: