Grant Amount vs. Requested Amount

Grant Amount vs. Requested Amount

This chart provides a view of the grant amounts requested by applicants compared to the actual grant amounts that were paid.

Data Grid Setup

In (Grantee and Grant Management) Application History, create and save a Data Grid view that contains (at least) the following:

Table: AppHistory

Columns:

(AppHi) Grant Amount

(AppHi) Requested Amt

Selections:

(AppHi) Action: From Approved through Approved.

Chart Setup

1. Open the appropriate Data Grid view, and click the FIMS Chart It button.

2. On the Data tab, do the following:

• Add the Grant Amt and Requested Amt data field to the chart.
• In the Group By and Display drop-downs, select Grant Date.

  Data Tab
  

3. On the Group By tab, select the Year checkbox in the For Dates, Chart By section.

4. Click the Chart button. 

Finished Chart

This chart uses the following settings:

• Side by Side (via General Properties).
• Cylinder (via Series Properties).
• Show Gridlines (via Y Axes Settings).
• Legend