Sales chart template
Sales Pipeline Chart Template
Open pipeline value at each deal stage, from first contact to verbal commit, drawn as horizontal bars in stage order.
See how much open pipeline sits at each stage of your sales process. The template draws $6.73 million of open deals across six stages, from prospecting to verbal commit, as horizontal bars in stage order.
Sales Pipeline by Stage
A live horizontal bar chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the sales pipeline by stage chart shows
Prospecting holds the most value in the sample at $2.15 million across 86 deals, and the value narrows at each step down to $310,000 across 7 deals at verbal commit. The drop between stages shows where deals stall or fall out.
Horizontal bars keep long stage names readable, and the stage order follows the way your team works a deal. The sheet also keeps the count of open deals at each stage for a second chart.
About the sample data
Pipeline value is the amount on each open opportunity in the CRM, counted at its current stage on the last day of the quarter. Deal amounts are rep estimates until a proposal is sent, so the early stages are the least precise.
Sample data
Sample data for the sales pipeline by stage template
The template loads these 6 rows. Keep the same columns, replace the rows with your own numbers, and the horizontal bar chart redraws to match.
Stage
Categories
Open Deals
Kept in the sheet for other charts
Pipeline Value
Values
| Stage | Open Deals | Pipeline Value |
|---|---|---|
| Prospecting | 86 | 2,150,000 |
| Qualified | 54 | 1,620,000 |
| Demo Completed | 38 | 1,240,000 |
| Proposal Sent | 24 | 890,000 |
| Negotiation | 13 | 520,000 |
| Verbal Commit | 7 | 310,000 |
How to use it
How to adapt the sales pipeline by stage template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Export open opportunities from your CRM with their current stage and amount, then total them by stage, or upload one row per deal and let the chart add them up.
- 3 List the stages in the order your team works them so the bars read from top to bottom like a funnel.
- 4 Switch the y axis to Open Deals to chart the number of deals at each stage instead of their value.
- 5 Pull the export on the same day each month or quarter so pipeline snapshots compare cleanly over time.
- 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
Sales Pipeline by Stage template FAQ
What is a sales pipeline chart?
A sales pipeline chart shows the open deals at each stage of the sales process, usually by total value or deal count. It shows how much revenue could close and where deals tend to drop out.
Should I use a funnel chart or a bar chart for a pipeline?
A horizontal bar chart in stage order reads like a funnel and keeps the values on a common scale, so stage to stage drops are easy to compare. It also handles long stage names well.
Can I chart pipeline by sales rep as well as stage?
Yes. Add a Sales Rep column to the sheet and switch to a stacked or grouped bar chart. Each rep becomes a color within every stage.
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 horizontal bar chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the horizontal bar chart maker page.
More templates
Related chart templates
Quarterly 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 templateQuarterly Sales Goal
Gauge ChartClosed won deals for one sales team over a quarter, added up and shown on a gauge against the team quota.
View templateProduct Category Mix by Store
Mekko ChartRevenue by product category for each retail store location.
View templateSupport Tickets by Day and Hour
HeatmapCustomer support ticket volume by day of the week and time block.
View templateSee all Sales Chart Templates, or browse all chart templates.
Make your own horizontal bar chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.