Using the PROFILER.XLM Macro

To run the macro, follow these steps from within Microsoft Excel:

1. Open PROFILER.XLM by choosing Open from the File menu.
2. Open the tab-delimited report that was created by PLIST by choosing Open from the File menu.
3. If you have several open worksheets, activate the one containing the profiler data by selecting it with the mouse or by choosing its title from the Windows menu.
4. Run the macro:
   • Press Ctrl+C for a chart based on hit counts.
   • Press Ctrl+T for a chart based on timing.

You cannot get a timing chart if the report contains only counting or coverage information.

The macro typically takes only a few seconds to execute. When it is complete, Microsoft Excel displays a 3-D bar chart based on the results in the report. You can change the chart type by using the Gallery menu.

This macro copies the data in the report to another worksheet before processing it. The original tab-delimited report is left untouched.