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

Sample data for the Sales Pipeline by Stage chart template
StageOpen DealsPipeline Value
Prospecting862,150,000
Qualified541,620,000
Demo Completed381,240,000
Proposal Sent24890,000
Negotiation13520,000
Verbal Commit7310,000

How to use it

How to adapt the sales pipeline by stage template

  1. 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
  2. 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. 3 List the stages in the order your team works them so the bars read from top to bottom like a funnel.
  4. 4 Switch the y axis to Open Deals to chart the number of deals at each stage instead of their value.
  5. 5 Pull the export on the same day each month or quarter so pipeline snapshots compare cleanly over time.
  6. 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.

Make your own horizontal bar chart in seconds

InstaCharts makes data visualization easy, so you can build clear reports without design experience.