Excel does not include a native variable-width column chart type: ordinary column-chart bars share the same width. You can make a proportional-looking version by calculating each bar’s share of the total width and drawing rectangles over a fixed chart plot area, or use a specialized charting tool if the graphic must update automatically.
What a Variable-Width Column Chart Shows
A variable-width column chart uses horizontal width for one measure and vertical height for another. For example, a retailer might make each product category’s column wider in proportion to its sales volume and taller in proportion to its profit margin. The viewer can compare two dimensions in one display, but must understand that width and height have different meanings.
When both width and height represent quantities, the rectangle’s area also represents a quantity: width multiplied by height. That can be useful, but it can also be misleading if readers compare only the height. A wide, short rectangle may have more area than a narrow, tall one. Label the dimensions clearly and explain whether area itself has a meaning.
Charts of this general kind are sometimes called variable-width column charts or Marimekko charts. A Marimekko chart commonly represents two categorical dimensions, with widths and heights both contributing to the visual comparison. Terminology is not perfectly consistent, so decide what each dimension means before choosing a charting method.
Why Excel Does Not Make Bar Widths Variable
A standard Excel column chart places categories along a category axis and gives their columns a consistent width. The Gap Width setting changes the space between columns, but it does not assign a different width to each category. A date axis can space dates according to time, yet that does not turn each column into a rectangle whose width is proportional to an independent data value.
This distinction matters because changing the overall gap width is not the same as encoding a width variable. If one group should occupy 20% of the chart and another 50%, a normal column chart cannot express that by assigning different widths to individual columns. A histogram also is not automatically the answer: Excel’s histogram chart uses bins, and its standard presentation is not a general-purpose two-variable chart with independently controlled rectangle dimensions.
For a one-off report, manually drawn rectangles can provide a clear visual. For a dashboard that refreshes frequently, use a charting method or add-in that supports variable-width rectangles, or consider another chart that communicates the data accurately without manual layout.
Plan the Data and Choose What Width Means
Start with one row per category and two numeric measures: a width measure and a height measure. Suppose three product groups have widths of 20, 30, and 50 units, and heights of 40, 70, and 50. The widths total 100, so the columns should occupy 20%, 30%, and 50% of the available horizontal plotting area. The tallest height, 70, can define the top of the vertical scale.
It is important to distinguish a width value from a category label. If a width represents population, sales, or time covered, its units and meaning should be stated in a subtitle, axis label, or note. If widths are simply chosen to fit names, the chart is not encoding a second quantitative measure and may imply a relationship that does not exist.
Use a consistent scale. Widths should be proportional to their original values, not independently stretched to make each rectangle look attractive. Heights should share one baseline, usually zero for a column-style display, unless there is a clear reason to use another baseline. Avoid comparing widths and heights as though they were the same unit.
Calculate Proportions in the Worksheet
For this example, put category names in A2:A4, width values in B2:B4, and height values in C2:C4. Put the width share in D, the cumulative left edge in E, and the height scaled to the tallest value in F. These helper columns turn the source values into proportions that can guide the drawing.
With width values in B2:B4, enter this in D2 and fill down through D4: =B2/SUM($B$2:$B$4). The results are 0.2, 0.3, and 0.5, or 20%, 30%, and 50% of the total width.
With the width proportions in D2:D4, enter this in E2 and fill down through E4: =SUM($D$2:D2)-D2. The left-edge positions are 0, 0.2, and 0.5. Adding each row’s width share to its left edge gives its right edge, so the rectangles meet without gaps.
With height values in C2:C4, enter this in F2 and fill down through F4: =C2/MAX($C$2:$C$4). The results are about 0.571, 1, and 0.714. They represent heights relative to the tallest rectangle. Keep the original values visible in the finished chart or a nearby table; normalized values are for positioning, not a replacement for the data.
Build a Static Version with Excel Shapes
This practical desktop method creates a clean, manually maintained graphic. It is best for a presentation or report with a stable data set, not a chart that must redraw itself after every refresh. In Excel for Microsoft 365 on Windows:
- Prepare the data and helper columns above. Decide the chart’s width and height, and leave room for a title, labels, and any explanatory note.
- Use a blank area of the worksheet as the drawing surface. You can insert a chart as a background scaffold, but a simple worksheet area with a baseline and labels is often easier to manage. If you use a chart, set its plot-area boundaries and axis scale before placing rectangles.
- Calculate each rectangle’s width as its width proportion multiplied by the usable drawing width. Calculate its height as its normalized height multiplied by the usable drawing height. Place its left edge using the cumulative position in column E, measured from the left edge of the plotting area. Place its bottom on the common baseline.
- Choose Insert > Shapes > Rectangle, then draw each rectangle in the plotting area. Use matching fills and no outline, or a thin outline, so adjacent shapes are easy to distinguish. Avoid adding gaps unless gaps are intentionally part of the design; gaps change the apparent width.
- Add category names and, where useful, the original width and height values. Use text boxes or worksheet cells for labels. Include a clear title or note such as Width = sales volume; height = margin, and identify units.
- Review the chart at its final display size. Check that the rectangles touch the baseline, widths add to the full plotting width, labels do not overlap, and the narrowest categories remain visible.
To draw a shape inside a chart object, select the chart before choosing Insert > Shapes. Exact placement is easiest when the chart and plot area are already sized. If you instead draw worksheet shapes over a chart, keep them aligned when moving or resizing either object. Excel for Mac also supports shapes, though ribbon organization and precision controls can differ. Excel for the web is less convenient for detailed shape alignment, so desktop Excel is the safer choice for building this manually.
Make the Graphic Easier to Read
Variable widths create a useful overview, but readers do not estimate area or width as precisely as they compare aligned lengths. Include labels or a small data table when exact comparisons matter. Keep the number of categories manageable; many narrow columns leave too little room for labels and make width differences hard to see.
- Use a single, meaningful baseline for heights, and show the height units.
- Explain whether width represents a total, a time span, a population, or another measure.
- Use a restrained color palette. Color can identify groups, but should not introduce an unexplained third variable.
- Keep category order purposeful, such as sorting by a measure or preserving a natural sequence.
- Check contrast and do not rely on color alone to distinguish categories.
For accessibility, give the chart a descriptive title and provide the underlying values in nearby worksheet cells or a table. Text labels placed on rectangles can become cramped; outside labels or a legend may work better for narrow groups. If the rectangles’ area is not intended to represent a measure, say so explicitly to prevent readers from treating area as meaningful.
Limitations and Alternatives
Shapes are not linked to the cell values that determined their dimensions. If a width or height changes, the formula results update, but the rectangles do not automatically redraw themselves. You must reposition or resize them, then review labels and alignment. Moving the chart, changing its plot area, or changing the scale can also require manual corrections.
A standard column chart is preferable when all categories should have equal visual weight and the main task is comparing heights. A bar chart may be easier to label when category names are long. A scatter chart is useful when both axes are numeric and the goal is to show positions or relationships rather than filled rectangles. If the width variable is a bin range, a histogram may suit the question better, though it has a different purpose and interpretation.
For a regularly refreshed Marimekko-style report, investigate a dedicated Excel add-in or another visualization platform that supports variable-width rectangles. Confirm that its data refresh, labeling, accessibility, and licensing meet your requirements. Do not assume that a stacked column chart’s Gap Width control or an ordinary histogram will provide independently variable widths; they do not offer the same encoding.
Frequently Asked Questions
Can Excel make a variable-width column chart automatically?
Not with the standard built-in column chart type. Excel keeps category column widths consistent. Shapes can imitate variable widths for a static graphic, while an add-in or another charting tool may be more suitable for automatic updates.
Is a variable-width column chart the same as a Marimekko chart?
The terms overlap. A Marimekko chart commonly uses category widths and segment heights to represent two dimensions, with rectangle area often carrying meaning. A variable-width column chart may use one rectangle per category and may not treat area as a measure. Define the encoding rather than relying only on the name.
Does Gap Width change the width of each Excel column separately?
No. Gap Width adjusts the spacing between columns in a series. It does not let you assign different widths to individual categories.
How do I update the chart when the source numbers change?
Recalculate the helper columns, then manually adjust the rectangle sizes and positions to match the new proportions. Since drawn shapes are not linked to those formulas, a frequently changing report should use an automated charting option instead.
Should the rectangle area represent the data?
Only if that is an intentional part of the design. If both width and height represent quantities, area combines them, which can be meaningful but may be easy to misread. State what width and height mean and provide labels or a table for precise comparisons.
Related
- Room List Template Excel: How to Build and Use One
- Resource List Excel Template: Set Up, Track, and Share
- Replace in Excel: Find and Replace Text, Values, and More
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Bar Chart in Cell Excel: How to Make OneExcel does not put a standard bar chart inside a worksheet cell, but you can create an in-cell…
- Power Pivot Connection Settings: Where to Find ThemIn Excel for Microsoft 365 on Windows, find Power Pivot connections by selecting Power Pivot > Manage, then,…
- Excel Waterfall Chart Data Labels: Add and Format ThemTo add labels to an Excel waterfall chart in Microsoft 365 for Windows, select the chart, then choose…
- Excel Dashboard Inspo: Ideas, Layouts, and Design TipsFor Excel dashboard inspo, start with one clear question your dashboard should answer, then build a compact view…
- Basic Gantt Chart Template in Excel: Build One FastA basic Gantt chart template in Excel is a task list paired with a calendar grid, where colored…
- Excel Power Pivot: Add Rows to a Table and RefreshTo add a row to a Power Pivot table, add it to the table or other source that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.