To Graph Extracted Path Data in Excel

The following is presented as a demonstration of how easy it is to obtain graphical plots of Autodesk Vehicle Tracking path data in Windows Excel 2007. The procedure will vary in other spreadsheet programs.

  1. Generate a short path with an articulated vehicle and extract the data as described in To Extract Path Data.
  2. Open Windows Excel.
  3. Open the CSV file containing your extracted path data.
  4. Select the columns labelled Actual Steering Angle and Unit 1-2 Articulation Angle by clicking on the column letter designator.
  5. On the ribbon, select Insert Line From Chart.
  6. Select one of the line graph types.

    A graph is inserted showing steering angle and articulation angle varying with distance along the path. Select and right click to change the chart type or edit the formatting options.