User manual

9 Graphing Call History Results

If you have Microsoft Excel 2000 installed, the results of the current profile can be sent to Excel

automatically to display a pie chart of the call results. Select the Graph button after or during a sweep.

There will be a delay while Excel starts. When it does, you will be prompted to enable Macros. Click to

enable Macros; then after the spreadsheet loads, click on the large yellow button entitled “Click here to

create a pie chart of your sweep results.” If you don’t have Excel 2000 installed, or you don’t have any

call history results to graph, an error message will be displayed.

Sample PhoneSweep Chart

Like any other Excel graph, the graph produced can be edited. For example, if you want to change the

title, you can click on it and edit it. You can also change the graph to a column chart by clicking on the

pie chart and going to “Selected Data Series” under Format. For more information on editing the chart,

see your Excel 2000 manual.

The Graph button also exports your PhoneSweep call results into Excel spreadsheets, eliminating the

need to use PhoneSweep’s Export button to do so. In the lower left corner of the chart, the raw call history

data generated by your sweep will appear under the “data” tab. The summary data, including the final call

result assigned to each phone number appears under the “lookup” tab. You can save these sheets in Excel

2000 and use them like any other Excel spreadsheet. For an explanation of the data fields, see Section

6.3.1, Exporting Call History.