You are here: Writing Reports > Adding a Chart to a Report

Adding a Chart to a Report

The Chart Options section of the Report Options, Step 2 of 2 page allows you to add and define a chart for your report. The chart uses the same view as the rest of the report, but you can specify different fields for the chart than you did for the report.

Example: Forecast Value by Sales Rep

This example demonstrates how to add a chart to an opportunity list report to show the Total Forecast Value by Sales Rep as a horizontal bar chart.

First, create the list report based on the Opportunity Summary Report Source according to the following specifications.

Report columns should include:

Company : Company Name
Person : Person
Opportunity : Description
Opportunity : Stage
Opportunity : Status
Opportunity : Close By (date)
Opportunity : Certainty%
Opportunity : Forecast (summed)

Further specifications include:

Search criteria of Opportunity : Assigned To, Opportunity : Stage, Opportunity : Status, Opportunity : Close By, and Opportunity : Forecast.
Grouping by the Sales Rep (Opportunity Assigned To) in order to get the Forecast totals by Rep.
Sorting by Opportunity Assigned To and the Forecast amount.
Right justify numerical columns.

To add the chart:

Select the Edit button next to the report you want to add the chart to. The Report Options, Step 1 of 2 page is displayed.
Select the Continue button. The Search Criteria for Report page is displayed.
Click on the Continue button. The Report Options, Step 2 of 2 page is displayed.
Scroll to the Chart Options panel of the page.

Complete the details in the Chart Options panel and select the Save button. Refer to Report Fields and Buttons for information on the Chart Options fields.
To view the chart, run the report.

Go to Writing Reports home page...