+ Reply to Thread
Results 1 to 6 of 6

How to PLot 3D LINES over TIME in excel

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    How to PLot 3D LINES over TIME in excel

    below is a table of time, x, y and z coordinates, the XYZ portion defines the path an object moved over time, is it possible to somehow plot at least the x,y,z portion in a 3D type of chart? I'm trying to figure out how to also show this OVER TIME but I'm not that smart lol

    excelforum.xlsx

    1:13:50 260016.6769 371350.1597 8.300000191
    1:13:55 260016.683 371350.2063 8.300000191
    1:14:00 260016.6682 371350.2542 8.300000191
    1:14:05 260016.6978 371350.2992 8.5
    1:14:10 260016.7049 371350.3285 8.5
    1:14:15 260016.7085 371350.3597 8.5
    1:14:20 260016.6867 371350.3879 8.300000191
    1:14:25 260016.7118 371350.3971 8.5
    1:14:30 260016.6975 371350.4247 8.699999809
    1:14:35 260016.7286 371350.4119 9.100000381
    1:14:40 260016.7426 371350.4118 9.100000381
    1:14:45 260016.7226 371350.3903 8.899999619
    1:14:50 260016.7137 371350.3599 9.100000381
    1:14:55 260016.7119 371350.3098 9.100000381
    1:15:00 260016.7071 371350.2674 9.199999809
    1:15:05 260016.6976 371350.2203 9
    1:15:10 260016.6846 371350.1699 9.199999809
    1:15:15 260016.6841 371350.1112 9
    1:15:21 260016.671 371350.0572 8.800000191
    1:15:26 260016.6482 371350.0258 8.399999619
    1:15:31 260016.6263 371350.0081 8.199999809
    1:15:36 260016.5965 371349.9948 7.800000191
    1:15:41 260016.5808 371349.9893 7.5
    1:15:46 260016.571 371349.9774 7.300000191
    1:15:51 260016.5441 371349.9618 6.900000095
    1:15:56 260016.5273 371349.9571 6.5
    1:16:01 260016.5454 371349.9518 6.300000191
    1:16:06 260016.5199 371349.962 6
    1:16:11 260016.5058 371349.9902 5.599999905
    1:16:16 260016.5065 371350.0355 5.199999809
    1:16:21 260016.4865 371350.0572 4.800000191
    1:16:26 260016.4875 371350.1042 4.400000095
    1:16:31 260016.4733 371350.136 4
    1:16:36 260016.4689 371350.1596 3.599999905
    1:16:41 260016.4536 371350.1507 3
    1:16:47 260016.4498 371350.1434 2.799999952
    1:16:52 260016.4341 371350.116 2.200000048
    1:16:57 260016.4291 371350.0764 1.200000048
    1:17:02 260016.4183 371350.0828 0.100000001
    1:17:07 260016.4399 371350.0995 -1
    1:17:12 260016.471 371350.1355 -2.299999952
    1:17:17 260016.5283 371350.1522 -3.299999952
    1:17:22 260016.6061 371350.1851 -4.599999905
    1:17:27 260016.6743 371350.2223 -5.599999905
    1:17:32 260016.7422 371350.2527 -6.900000095
    1:17:37 260016.8595 371350.2965 -8
    1:17:42 260016.9826 371350.3411 -9.100000381
    1:17:47 260017.0979 371350.3722 -10
    1:17:52 260017.2567 371350.4157 -11.30000019
    1:17:57 260017.4024 371350.4173 -12.39999962
    1:18:02 260017.5204 371350.3893 -13.5
    1:18:08 260017.6685 371350.2463 -14.80000019
    1:18:13 260017.8317 371349.9116 -15.80000019
    1:18:18 260017.9585 371349.3079 -17.10000038
    1:18:23 260018.0655 371348.4241 -17.89999962
    1:18:28 260018.1667 371347.4005 -19
    1:18:33 260018.3382 371346.6573 -20.29999924
    1:18:38 260018.4853 371346.3085 -21.39999962
    1:18:43 260018.7951 371346.4442 -22.29999924
    1:18:48 260018.9246 371345.9011 -23.39999962
    1:18:53 260019.2135 371345.0421 -24.70000076
    1:18:58 260019.3545 371343.8461 -25.79999924
    1:19:03 260019.5612 371342.9277 -26.70000076
    1:19:08 260020.8545 371341.8378 -27.70000076
    1:19:13 260022.223 371340.8844 -28.39999962
    1:19:18 260021.9965 371339.672 -30
    1:19:23 260021.6519 371338.8616 -31.20000076
    1:19:28 260022.5244 371337.6488 -32
    1:19:33 260023.258 371336.8329 -33
    1:19:39 260023.4426 371335.4158 -34.09999847
    1:19:44 260023.5452 371334.6701 -35.20000076
    1:19:49 260023.627 371333.551 -36.40000153
    1:19:54 260023.7951 371332.6663 -37.5
    1:19:59 260024.1328 371331.3711 -38.40000153
    1:20:04 260024.4906 371330.1097 -39.40000153
    1:20:09 260024.8659 371329.321 -40.59999847
    1:20:14 260025.2398 371328.0756 -41.79999924
    1:20:19 260025.5507 371327.2 -42.70000076
    1:20:24 260025.8977 371326.0043 -43.59999847
    1:20:29 260026.2313 371325.0054 -44.29999924
    1:20:34 260026.2385 371324.2281 -44.59999847
    1:20:39 260026.5251 371323.1408 -45.59999847
    1:20:44 260027.0333 371322.1928 -46.70000076
    1:20:49 260027.4351 371320.8048 -47.59999847
    1:20:54 260027.9458 371319.9314 -48.5
    1:20:59 260028.3991 371319.394 -49.59999847
    1:21:04 260028.9033 371319.5536 -50.29999924
    1:21:09 260029.2497 371319.5881 -50.79999924
    1:21:14 260029.2388 371319.4079 -50.70000076
    1:21:20 260029.2135 371319.1198 -50.79999924
    1:21:25 260029.2099 371319.0855 -50.70000076
    1:21:30 260029.2166 371319.1947 -50.79999924
    1:21:35 260029.2679 371319.1741 -50.79999924
    1:21:40 260029.3423 371319.1656 -51
    1:21:45 260029.2409 371319.199 -50.79999924
    1:21:50 260029.331 371319.1153 -51
    1:21:55 260029.3381 371319.1059 -51
    1:22:00 260029.3283 371319.1458 -51
    1:22:05 260029.3247 371319.1782 -51
    1:22:10 260029.2194 371319.1656 -50.79999924
    1:22:15 260029.3126 371319.149 -51
    1:22:20 260029.2187 371319.1536 -50.79999924
    1:22:25 260029.2141 371319.1649 -51
    1:22:30 260029.309 371319.1811 -50.79999924
    1:22:35 260029.2181 371319.178 -51
    1:22:40 260029.3247 371319.1782 -50.79999924
    1:22:45 260029.2133 371319.1799 -51
    1:22:50 260029.3199 371319.1733 -51
    1:22:55 260029.315 371319.1559 -51
    1:23:00 260029.3145 371319.1629 -50.79999924
    1:23:06 260029.3063 371319.1448 -50.90000153
    1:23:11 260029.22 371319.1336 -50.70000076
    1:23:16 260029.2143 371319.1201 -50.79999924
    1:23:21 260029.3157 371319.0741 -51
    1:23:26 260029.2249 371319.0837 -50.79999924
    1:23:31 260029.3293 371319.0879 -50.79999924
    1:23:36 260029.236 371319.0886 -50.79999924
    1:23:41 260029.3262 371319.0759 -51
    1:23:46 260029.3416 371319.0746 -50.70000076
    1:23:51 260029.245 371319.0654 -50.70000076
    1:23:56 260029.3282 371319.0659 -50.90000153
    1:24:01 260029.2413 371319.0805 -50.70000076
    1:24:06 260029.3265 371319.1084 -51
    1:24:11 260029.2322 371319.0948 -50.90000153
    1:24:16 260029.2446 371319.0866 -50.79999924
    1:24:22 260029.3395 371319.1001 -50.79999924
    1:24:27 260029.3315 371319.0728 -51
    1:24:32 260029.2472 371319.1117 -51
    1:24:37 260029.2511 371319.1128 -50.79999924
    1:24:42 260029.3469 371319.1294 -51
    1:24:47 260029.2415 371319.1117 -50.79999924
    1:24:52 260029.2339 371319.1161 -50.79999924
    1:24:57 260029.3444 371319.1151 -51
    1:25:02 260029.2463 371319.1067 -50.79999924
    1:25:07 260029.2421 371319.0774 -50.79999924
    1:25:12 260029.249 371319.0816 -51
    1:25:17 260029.2577 371319.0846 -50.79999924
    1:25:22 260029.2584 371319.0714 -50.79999924
    1:25:27 260029.2569 371319.0715 -50.79999924
    1:25:32 260029.2513 371319.0723 -50.79999924
    1:25:37 260029.3422 371319.0434 -51
    1:25:42 260029.245 371319.0642 -50.79999924
    1:25:47 260029.2436 371319.0716 -50.79999924
    1:25:52 260029.2528 371319.0703 -50.79999924
    1:25:57 260029.3532 371319.0757 -51
    1:26:02 260029.2602 371319.1058 -50.90000153
    1:26:07 260029.2639 371319.0853 -50.79999924
    1:26:13 260029.2603 371319.1127 -50.79999924
    1:26:18 260029.2635 371319.1015 -50.90000153
    1:26:23 260029.2554 371319.0927 -50.90000153
    1:26:28 260029.2667 371319.1277 -50.79999924
    1:26:33 260029.2919 371319.3089 -50.90000153
    1:26:38 260029.2891 371319.2703 -50.90000153
    1:26:43 260029.271 371319.1794 -50.90000153
    1:26:48 260029.2875 371319.2561 -50.90000153
    1:26:53 260029.2816 371319.2967 -51
    1:26:58 260029.2752 371319.2724 -51
    1:27:03 260029.1632 371319.2795 -50.90000153
    1:27:08 260028.5195 371319.4227 -49.70000076
    1:27:13 260027.5998 371319.5211 -48.90000153
    1:27:18 260026.8864 371319.3847 -48.20000076
    1:27:23 260026.3711 371319.5797 -47
    1:27:28 260025.9168 371320.1428 -46
    1:27:33 260025.5207 371320.8207 -45
    1:27:38 260024.9634 371321.2542 -43.90000153
    1:27:44 260024.5185 371321.4804 -42.90000153
    1:27:49 260024.5406 371321.8289 -42.90000153
    1:27:54 260024.5583 371322.2306 -42.90000153
    1:27:59 260024.5935 371322.8418 -42.90000153
    1:28:04 260024.8372 371324.729 -42.59999847
    1:28:09 260024.854 371326.0552 -42.90000153
    1:28:14 260024.8687 371326.8755 -42.90000153
    1:28:19 260024.9067 371327.3115 -42.90000153
    1:28:24 260024.9717 371327.9966 -42.90000153
    1:28:29 260025.0729 371329.3966 -42.79999924
    1:28:34 260025.1103 371330.358 -42.90000153
    1:28:39 260025.1825 371330.9282 -42.90000153
    1:28:44 260025.2649 371331.736 -42.90000153
    1:28:49 260025.3341 371332.6267 -42.90000153
    1:28:54 260025.4106 371333.6143 -42.90000153
    1:29:00 260025.4869 371334.4548 -42.90000153
    1:29:05 260025.561 371335.241 -42.90000153
    1:29:10 260025.6379 371336.0715 -42.90000153
    1:29:15 260025.7302 371337.0458 -42.90000153
    1:29:20 260025.8239 371337.9043 -42.90000153
    1:29:25 260025.9077 371338.8532 -42.79999924
    1:29:30 260025.9989 371339.7585 -42.79999924
    1:29:35 260026.0814 371340.6664 -42.90000153
    1:29:40 260026.1791 371341.5322 -42.90000153
    1:29:45 260026.2642 371342.3761 -42.90000153
    1:29:50 260026.3662 371343.2712 -42.79999924
    1:29:55 260026.4544 371344.151 -42.90000153
    1:30:00 260026.545 371344.9925 -42.79999924
    1:30:05 260026.6504 371345.8806 -42.79999924
    1:30:10 260026.7364 371346.7928 -42.79999924
    1:30:15 260026.8396 371347.655 -42.79999924
    1:30:20 260026.9259 371348.5027 -42.79999924
    1:30:25 260027.0276 371349.3967 -42.79999924
    1:30:31 260027.1371 371350.289 -42.79999924
    1:30:36 260027.2296 371351.1405 -42.79999924
    1:30:41 260027.34 371352.0254 -42.90000153
    1:30:46 260027.476 371353.0768 -42.90000153
    1:30:51 260027.5883 371353.9273 -42.90000153
    1:30:56 260027.6974 371354.8141 -42.90000153
    1:31:01 260027.8208 371355.6761 -42.90000153
    1:31:06 260027.9223 371356.5408 -42.90000153
    1:31:11 260028.0368 371357.4286 -42.90000153
    1:31:16 260028.1582 371358.3063 -42.90000153
    1:31:21 260028.2719 371359.187 -42.90000153
    1:31:26 260028.3869 371360.0475 -42.90000153
    1:31:31 260028.5047 371360.908 -42.90000153
    1:31:36 260028.6294 371361.7977 -43
    1:31:41 260028.7534 371362.6834 -43
    1:31:46 260028.8776 371363.5312 -43
    1:31:51 260029.003 371364.3966 -43
    1:31:56 260029.1305 371365.2813 -43
    1:32:01 260029.257 371366.1629 -43
    1:32:06 260029.3843 371367.0192 -43
    1:32:11 260029.5169 371367.8926 -43
    1:32:16 260029.6468 371368.7711 -43
    1:32:21 260029.7714 371369.5987 -43
    1:32:27 260029.9005 371370.4742 -43
    1:32:32 260030.0289 371371.3699 -43
    1:32:37 260030.1995 371372.4029 -43
    1:32:42 260030.3341 371373.2813 -43
    1:32:47 260030.4773 371374.1496 -43
    1:32:52 260030.6069 371374.9896 -43
    1:32:57 260030.7529 371375.8841 -43
    1:33:02 260030.9021 371376.7715 -43
    1:33:07 260031.0347 371377.6641 -43
    1:33:12 260031.1858 371378.4955 -43
    1:33:17 260031.3266 371379.3921 -43
    1:33:23 260031.4786 371380.24 -43
    1:33:28 260031.6317 371381.1384 -43
    1:33:33 260031.7862 371381.9914 -43
    1:33:38 260031.9431 371382.8412 -43
    1:33:43 260032.1001 371383.7346 -43
    1:33:48 260032.2766 371384.7562 -43
    1:33:53 260032.4345 371385.6354 -43
    1:33:58 260032.584 371386.4995 -43
    1:34:03 260032.7525 371387.4129 -43
    1:34:08 260032.92 371388.2573 -43
    1:34:13 260033.0734 371389.1031 -43
    1:34:18 260033.2371 371390.0045 -42.90000153
    1:34:23 260033.3984 371390.8663 -42.90000153
    1:34:28 260033.5713 371391.7291 -43
    1:34:33 260033.737 371392.5728 -42.90000153
    1:34:38 260033.9063 371393.4508 -42.90000153
    1:34:43 260034.0869 371394.3468 -42.90000153
    1:34:49 260034.2576 371395.2036 -42.90000153
    1:34:54 260034.4303 371396.0803 -42.90000153
    1:34:59 260034.6135 371396.9328 -43
    1:35:04 260034.784 371397.8128 -42.90000153
    1:35:09 260034.9464 371398.5906 -43
    1:35:14 260035.1784 371399.6511 -42.90000153
    1:35:19 260035.3491 371400.5361 -42.90000153
    1:35:24 260035.5324 371401.3714 -42.90000153
    1:35:29 260035.707 371402.2786 -43
    1:35:34 260035.8945 371403.1098 -43
    1:35:39 260036.1105 371404.0753 -43
    1:35:44 260036.2653 371404.8025 -43
    1:35:49 260036.4845 371405.8116 -43
    1:35:54 260036.629 371406.5165 -43
    1:35:59 260036.8752 371407.5485 -42.90000153
    1:36:04 260037.0168 371408.3103 -43
    1:36:09 260037.2623 371409.3169 -43
    1:36:14 260037.4122 371410.0897 -43
    Last edited by wings1080; 01-19-2016 at 11:51 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to PLot 3D LINES over TIME in excel

    Excel doesn't do 3D charts. You might look at http://www.andypope.info/charts/3drotate.htm
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: How to PLot 3D LINES over TIME in excel

    thanks that is way over my head unless you felt like using my table above and using it and showing me what you did? am I dreaming? lol

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to PLot 3D LINES over TIME in excel

    Hi Wings,

    I've been playing with this and I got this picture:Wings3DPts.jpg
    Attached Images Attached Images
    Last edited by xladept; 01-19-2016 at 04:04 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: How to PLot 3D LINES over TIME in excel

    cool what is it?

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to PLot 3D LINES over TIME in excel

    I don't know but check it out as I'm still playing

    I've plotted the differences on a half scale so it would fit. The x-axis is horizontal, the y-axis is vertical and the z-axis is oblique (at 45 degrees).

    I think the last one is correct, with the first one I forgot to multiply the z by the side of the square dimension and had a sign error
    Last edited by xladept; 01-19-2016 at 04:20 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Plot a benchark gap between two lines
    By Jilava in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-15-2015, 10:23 AM
  2. plot pairs of time points as lines
    By bream in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-01-2013, 12:10 PM
  3. Custom lines on xy plot
    By schnett in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-11-2006, 09:30 AM
  4. how do i plot data consisting of 1000 lines in excel sheet
    By novice in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-29-2005, 09:55 AM
  5. Replies: 3
    Last Post: 10-13-2005, 12:05 AM
  6. [SOLVED] Plot time scale in Excel
    By Shuvro Basu in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-04-2005, 05:06 PM
  7. Excel Scatter Plot with connected by smooth lines
    By Rosa Campos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-09-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1