Sales chart template
Won and Lost Deals by Industry Chart Template
Deals won and deals lost in each industry segment, drawn as horizontal bars so the industry names stay readable.
Compare won and lost deals across industry segments. The template draws two bars for each of six industries, so win rates are easy to compare at a glance.
Won and Lost Deals by Industry
A live horizontal grouped bar chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the won and lost deals by industry chart shows
Healthcare and Life Sciences and Financial Services both win about 61% of their decided deals in the sample. Government is the weakest segment, with 17 won and 26 lost for a 40% win rate.
Manufacturing, Retail and Ecommerce and Education sit between 54% and 56%. Horizontal bars leave room for the long industry names on the axis.
About the sample data
Counts opportunities in the CRM that reached a final stage in the last two quarters, grouped by the industry on the account record. Deals still open at the end of the period are excluded, and industry is self reported at signup.
Sample data
Sample data for the won and lost deals by industry template
The template loads these 12 rows. Keep the same columns, replace the rows with your own numbers, and the horizontal grouped bar chart redraws to match.
Industry
Categories
Outcome
Breakdown, one color per value
Deals
Values
| Industry | Outcome | Deals |
|---|---|---|
| Healthcare and Life Sciences | Won | 48 |
| Financial Services | Won | 42 |
| Manufacturing | Won | 35 |
| Retail and Ecommerce | Won | 31 |
| Education | Won | 22 |
| Government | Won | 17 |
| Healthcare and Life Sciences | Lost | 31 |
| Financial Services | Lost | 27 |
| Manufacturing | Lost | 29 |
| Retail and Ecommerce | Lost | 24 |
| Education | Lost | 19 |
| Government | Lost | 26 |
How to use it
How to adapt the won and lost deals by industry template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Count deals that reached a final stage, won or lost, and leave open deals out.
- 3 Use one row per industry per outcome with the deal count in a number column.
- 4 Switch to a 100% stacked bar chart to show each industry's win rate directly.
- 5 Chart deal value instead of deal count when large contracts matter more than volume.
- 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
Won and Lost Deals by Industry template FAQ
How do I show win rate by industry?
Use this template as a grouped bar for counts, or switch it to a 100% stacked bar chart so each bar shows the share of won and lost deals for that industry.
Why use horizontal bars for this chart?
Industry names are long. Horizontal bars put the names on the vertical axis where they fit on one line.
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 grouped bar chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the grouped bar 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 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 grouped bar chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.