Sales chart template
Product Category Mix by Store Chart Template
Revenue by product category for each retail store location.
Compare both the size of each store and its mix of product categories in one mekko chart. Bar widths show each store's share of revenue and the segments show how that revenue splits across categories.
Product Category Mix by Store
A live mekko chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the product category mix by store chart shows
The Suburban Mall store is the widest bar in the sample with $515,000 of revenue, and the Outlet is the narrowest at $246,000. Across all four stores, apparel brings in $649,000, footwear $522,000 and accessories $371,000.
A mekko chart answers two questions at once: which stores matter most and whether their category mix differs. Here the mix stays similar from store to store, with apparel the largest segment in each.
About the sample data
Revenue comes from point of sale exports for the trailing twelve months, net of returns and discounts. Online orders picked up in store are credited to the fulfilling location, which lifts stores near a distribution center.
Sample data
Sample data for the product category mix by store template
The template loads these 12 rows. Keep the same columns, replace the rows with your own numbers, and the mekko chart redraws to match.
Store
Bars, sized by their total
Category
Breakdown, one color per value
Revenue
Values
| Store | Category | Revenue |
|---|---|---|
| Downtown | Apparel | 185,000 |
| Downtown | Footwear | 142,000 |
| Downtown | Accessories | 96,000 |
| Uptown | Apparel | 156,000 |
| Uptown | Footwear | 118,000 |
| Uptown | Accessories | 84,000 |
| Suburban Mall | Apparel | 210,000 |
| Suburban Mall | Footwear | 175,000 |
| Suburban Mall | Accessories | 130,000 |
| Outlet | Apparel | 98,000 |
| Outlet | Footwear | 87,000 |
| Outlet | Accessories | 61,000 |
How to use it
How to adapt the product category mix by store template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Use one row per store per category with revenue in a number column.
- 3 Keep the categories to about five so each segment stays wide enough to label.
- 4 Use net revenue after returns so stores with high return rates compare fairly.
- 5 Switch to a 100% stacked bar chart if every store should have the same width.
- 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
Product Category Mix by Store template FAQ
What is a mekko chart?
A mekko or marimekko chart is a stacked bar chart where each bar's width is set by its total. It shows the size of each group and the mix inside it in one view.
What data do I need for a mekko chart?
A category column for the bars, a second category column for the segments and a number column for the values.
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 mekko chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the mekko 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 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 templateDepartment Budget by Expense Type
Horizontal Stacked Bar ChartHow each department's annual budget splits across salaries, software, travel and equipment, stacked into horizontal bars.
View templateSee all Sales Chart Templates, or browse all chart templates.
Make your own mekko chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.