Plot in Excel
Any of the data which can be graphed in RS2, can also be exported to Microsoft Excel and graphed in Excel. Data which may be exported to Excel includes:
- Material Query Data
- Bolt Data
- Liner Data
- Joint Data
To export and plot data in Excel:
- Use any of the graph options (Graph Material Query, Graph Bolt Data, Graph Liner Data, Graph Joint Data), select Plot in the Graph Data dialog.
- After a graph has been created in RS2, right-click on the graph and select Plot in Excel from the popup menu.
The following will occur:
- The Microsoft Excel program will automatically be launched (if you have Excel installed on your computer).
- The raw data used to generate a graph will be exported to an Excel spreadsheet.
- A graph will be created in Excel.
You can then customize the graph or process the data as desired, in Excel.