Share via


How to: Export Graph View Data to Microsoft Excel

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio Professional 

Visual Studio Express

Topic applies Topic does not apply Topic does not apply Topic does not apply

You can export the graph data to Microsoft Excel by using the Export Graph Data to Excel button on the Load Test Analyzer toolbar while in the Graphs view. For more information, see Load Test Analyzer Overview.

Note

  You can also use the drop-down list on Export Graph Data to Excel button to select Export Graph Data to Test (.csv) to export to a comma separated text file.

If you are exporting the data with the intension of using it for reporting purposes, it is recommended that you use the built-in reporting functionality instead. For more information, see Reporting Load Tests Results for Test Comparisons or Trend Analysis.

To export graph data to Microsoft Excel

  1. In the Load Test Analyzer, click Graphs on the load test toolbar.

    This displays load test results in graphs.

  2. On the Load Test Analyzer toolbar, click Export Graph Data to Excel button on the toolbar.

    Microsoft Excel opens and presents the graph data as shown in the following illustration.

    Microsoft Excel with Exported Graph Data

    Microsoft Excel with exported graph data

See Also

Tasks

How to: Create Custom Graphs in Load Test Results

Concepts

Analyzing Load Test Results in the Graphs View of the Load Test Analyzer

Load Test Analyzer Overview

Other Resources

Reporting Load Tests Results for Test Comparisons or Trend Analysis