Sales chart template
Sales Quota Attainment Gauge Template
Closed won deals for one sales team over a quarter, added up and shown on a gauge against the team quota.
Show how close your team is to its quarterly quota on a single gauge. The template adds up 14 closed won deals and compares the total with a $1,000,000 target.
Quarterly Sales Goal
A live gauge chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the quarterly sales goal chart shows
The sample deals add up to $873,500, which is 87% of the $1,000,000 quota with the gauge scale running to $1,200,000. Priya Shah closed $415,000 of that total, Marcus Lee $244,000 and Elena Novak $214,500.
The gauge sums every row in the sheet, so you can paste the CRM's closed won report as it is. Each new deal moves the gauge without any formulas.
About the sample data
Deals come from the CRM closed won report for July 1 to September 30, counted on the close date. Multi year contracts count only their first year value, and deals still in legal review are left out until they are signed.
Sample data
Sample data for the quarterly sales goal template
The template loads these 14 rows. Keep the same columns, replace the rows with your own numbers, and the gauge chart redraws to match.
Close Date
Kept in the sheet for other charts
Account
Kept in the sheet for other charts
Sales Rep
Kept in the sheet for other charts
Deal Amount
Value, added up into one number
| Close Date | Account | Sales Rep | Deal Amount |
|---|---|---|---|
| 2026-07-02 | Northwind Freight | Priya Shah | 72,000 |
| 2026-07-09 | Blue Harbor Foods | Marcus Lee | 38,500 |
| 2026-07-15 | Summit Dental Group | Priya Shah | 54,000 |
| 2026-07-22 | Cedar Ridge Schools | Elena Novak | 91,000 |
| 2026-07-30 | Lakeview Clinics | Marcus Lee | 46,500 |
| 2026-08-05 | Orbit Fitness | Elena Novak | 29,000 |
| 2026-08-12 | Granite Builders | Priya Shah | 83,000 |
| 2026-08-19 | Riverside Credit Union | Marcus Lee | 67,500 |
| 2026-08-27 | Maple Street Bakery | Elena Novak | 18,500 |
| 2026-09-03 | Pioneer Energy | Priya Shah | 112,000 |
| 2026-09-10 | Harborview Hotels | Marcus Lee | 58,000 |
| 2026-09-17 | Silverline Software | Elena Novak | 76,000 |
| 2026-09-24 | Westfield Veterinary | Marcus Lee | 33,500 |
| 2026-09-29 | Copperleaf Insurance | Priya Shah | 94,000 |
How to use it
How to adapt the quarterly sales goal template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Paste one row per closed deal with its amount, and the gauge adds them up.
- 3 Set the target and the maximum in the gauge options so the scale fits your quota.
- 4 Count multi year contracts at their first year value so the total matches how quota is measured.
- 5 Use the grouped gauge chart type to show one ring per rep against the same target.
- 6 Download the chart as a PNG, SVG or PDF, share it with a link, or embed it on a website. Sign up free to save it.
FAQ
Quarterly Sales Goal template FAQ
How does the gauge calculate quota attainment?
The gauge adds up the Deal Amount column across every row and draws the total against the target and maximum set in the gauge options.
Can I show each rep's progress?
Yes. Switch to a grouped gauge with Sales Rep as the breakdown. Each rep gets a ring that fills toward the target.
Is this chart template free?
Yes. Click Edit this template to open it in the InstaCharts chart maker with no account needed. Sign up free to save the chart, share it with a link or embed it on a website.
How do I use my own data with this template?
Open the template in the chart maker, then paste in your own spreadsheet or upload a CSV or Excel file with the same kind of columns. The new chart keeps this template's gauge chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the gauge chart maker page.
More templates
Related chart templates
Sales Pipeline by Stage
Horizontal Bar ChartOpen pipeline value at each deal stage, from first contact to verbal commit, drawn as horizontal bars in stage order.
View templateQuarterly Revenue by Region
Grouped Bar ChartRevenue across North America, Europe and Asia Pacific for four quarters.
View templateSales Rep Leaderboard
Bar ChartDeals closed and revenue generated by each sales representative on the team.
View templateWon and Lost Deals by Industry
Horizontal Grouped Bar ChartDeals won and deals lost in each industry segment, drawn as horizontal bars so the industry names stay readable.
View templateProduct Category Mix by Store
Mekko ChartRevenue by product category for each retail store location.
View templateCustomer Satisfaction Score
Grouped Gauge ChartSupport ticket ratings from 1 to 5, averaged for each support channel, with one ring per channel filling toward a perfect 5.
View templateSee all Sales Chart Templates, or browse all chart templates.
Make your own gauge chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.