Excel does not include a chart type named “Square Area Chart.” If you mean an Area chart displayed in a square-shaped frame, select your data and choose Insert > Insert Line or Area Chart > 2-D Area, then adjust the chart’s dimensions; if you mean square tiles whose areas represent values, use a Treemap or build a waffle-style grid instead.
What “square area chart” can mean
The phrase can describe two different ideas. One is an ordinary Area chart with a roughly square overall outline. The chart still shows values along axes, with the space beneath a line filled in. Its width and height change the chart’s appearance, but do not change the underlying data or make the filled region a set of value-sized squares.
The other meaning is a chart made of square or rectangular blocks, where each block’s area represents a quantity. This is a different visual encoding. Excel’s Treemap chart is the built-in option most closely related: it divides a rectangle into tiles sized according to values. Treemap tiles are not guaranteed to be squares, and the feature is not called a Square Area chart in Excel.
It helps to decide which meaning you want before building the chart. If the important message is how a measure changes over time, an Area chart may fit. If you want to compare the relative sizes of categories, a Treemap or a waffle chart is usually a better match.
How an Excel Area chart works
An Area chart plots a series of values against categories, commonly dates, and fills the region between the data line and the horizontal axis. For example, monthly website visits can be shown with months along the horizontal axis and visits on the vertical axis. The filled area gives the series visual weight, which can make broad changes easier to notice.
A basic Area chart is most readable when the horizontal categories have a meaningful order and the vertical values are comparable. It is often used for time series, such as monthly production or weekly sign-ups. It is less suitable for unrelated categories because connecting them implies a progression that may not exist.
Excel offers several area variants. A standard 2-D Area chart starts each series from the axis, so overlapping series can obscure one another. A Stacked Area chart adds series cumulatively, emphasizing the combined total and each series’ contribution. A 100% Stacked Area chart expresses each category as a share of the total, making proportions easier to compare while hiding differences in absolute totals.
When multiple series overlap, their order matters. In a standard Area chart, a later series can cover an earlier one. A line chart may be clearer when the goal is to compare several trends, while a stacked version is useful only when the cumulative interpretation makes sense.
Create a standard Area chart
For Microsoft Excel for Microsoft 365 on Windows, arrange the data with category labels in the first column and one or more series in adjacent columns. Put a descriptive heading at the top of each series column. For instance, column A might contain months and columns B and C might contain the values for two products. Select the complete range, including headings, then follow these steps:
- Open the Insert tab.
- Select Insert Line or Area Chart in the Charts group.
- Under 2-D Area, choose Area, Stacked Area, or 100% Stacked Area.
- Review the chart’s legend, axis labels, and series order. Use Chart Design > Switch Row/Column if Excel has interpreted the rows and columns in the opposite way from what you intended.
- Use Chart Design > Add Chart Element to add a chart title, axis titles, data labels, or other elements where useful.
If the source data is not in a single rectangular range, select the relevant category and value columns while holding Ctrl on Windows. Nonadjacent selections can be awkward, so putting the chart data into a clean, contiguous table is often simpler. If the chart has the wrong categories or series, right-click the chart and choose Select Data to review its source range and series settings.
Make the chart frame square
To make the overall chart look square, select its outer border and set equal height and width. On Windows, right-click the chart’s outer edge and choose Format Chart Area. In the formatting pane, open Size & Properties and enter matching values for Height and Width under Size. Depending on the ribbon layout and selection, the Format tab may also expose size boxes for the selected chart.
This makes the chart object square, not necessarily the plot area inside it. A title, legend, axis labels, and tick marks take up room, so the region containing the data may remain rectangular. Excel positions these elements automatically, and their placement can change the usable plot area. If a square plot is important, remove unnecessary elements or move the legend, then compare the inner plotting region rather than judging only the outside border.
Changing a chart’s proportions can also affect how steep or shallow the trends look. A narrow chart compresses changes horizontally; a short chart exaggerates them vertically. Keep the axis scale and chart proportions appropriate to the message, and avoid resizing solely to make the filled region resemble a square. A square outline does not make a chart more accurate by itself.
When you mean tiles sized by value
If the goal is to compare categories by the amount of area they occupy, insert a Treemap instead of an Area chart. Put category names in one column and their numeric values in another. If the data has hierarchy, include a column for each level, such as department, product group, and sales. Select the data and choose Insert > Insert Hierarchy Chart > Treemap. Excel assigns larger portions of the chart to larger values and uses nested groupings when hierarchical labels are present.
A Treemap is useful when there are many categories and the reader needs to see which groups account for the largest share. It is less effective for precise comparisons between similar values: viewers are generally better at comparing lengths than areas, and tiles can be difficult to distinguish when labels are long or values are close. Add clear labels, use a restrained color scheme, and consider a sorted bar chart when exact ranking matters.
Treemap tiles are rectangles arranged to fill the available chart space; Excel does not promise that each tile will be a perfect square. The tile shape depends on the data, hierarchy, and available layout. If the requirement is literally a grid of equal-sized square cells, a waffle chart is a closer concept, but it is not a standard chart type in Excel.
Build a waffle-style square grid
A waffle chart represents a total as a fixed number of equal cells, often 100. Each cell stands for the same fraction of the whole, and filled cells show the proportion for a category. For example, a result of 63% could be shown by coloring 63 cells in a 10-by-10 grid. This makes the unit size consistent, unlike a Treemap, where the tile dimensions vary.
Excel does not provide a one-click waffle chart command. A simple version can be assembled in a 10-by-10 range of cells, with cells formatted as squares by making column widths and row heights visually similar. Apply fills to the intended number of cells, or use conditional formatting driven by helper values. Because cells are not necessarily physically square under every screen zoom, printer setting, or font configuration, check the finished grid at the size where it will be displayed.
Waffle charts work best for one or a few percentages and a clearly defined denominator. They become cumbersome when comparing many categories or showing precise values. Include a numeric label such as 63% so readers do not have to count the cells, and explain what the percentage is a share of.
Choose the right chart for the question
- Use an Area chart to show a continuous-looking trend across ordered categories, especially time, and to emphasize the magnitude of a series.
- Use a Stacked Area chart when the total and the changing contribution of several series both matter. Avoid it if readers need to compare each series against a common baseline.
- Use a 100% Stacked Area chart when the focus is how proportions change, rather than how the total changes.
- Use a Treemap to show hierarchical categories and relative contributions with nested rectangular tiles.
- Use a waffle grid for an easily understood percentage made of equal units, particularly when a 100-cell representation is meaningful.
- Use a bar chart when accurate comparisons or a clear ranking among categories matter more than showing a filled area.
Another possible alternative is a Bubble chart, which encodes a third variable through bubble size while plotting two values on axes. It can be useful for three-variable comparisons, but circles with different areas are not as easy to compare precisely as bars. It is not a substitute for an Area chart simply because both use visual area.
Formatting and interpretation tips
Give the chart a title that identifies the measure and, where necessary, the period or unit. Label axes when the units are not self-evident. For an Area chart, check that the vertical axis starts at an appropriate baseline: the filled area is interpreted relative to that axis, so an unusual scale can make differences appear larger or smaller than expected. Do not hide a meaningful scale choice merely to make the chart look more dramatic.
Use distinct, accessible colors for multiple series and avoid relying on color alone to communicate a critical distinction. A legend should make clear which series each fill represents. If the data contains gaps, Excel may display them as empty spaces; select the chart and use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are plotted. Choose a connection option only if bridging a gap reflects the meaning of the data.
For dates, verify that Excel is treating the horizontal axis as intended. If date labels are uneven or crowded, try a different axis label interval or a line chart. If values are being treated as separate categories, check the source range and axis settings. Changing the chart’s width and height cannot fix a mistaken data selection or an inappropriate chart type.
Common problems and fixes
- The chart looks like a solid block. In a standard Area chart, later series may cover earlier ones. Try changing the series order in Select Data, using transparency sparingly, choosing a stacked option when appropriate, or switching to a line chart.
- The chart is square outside but not inside. Titles, legends, and axis labels reduce the plot area. Simplify or reposition those elements and resize the chart again.
- Category names or values are wrong. Use Chart Design > Select Data to inspect the chart range, category labels, and series. Make sure headings were included and that numeric values are actually stored as numbers.
- The filled areas suggest an incorrect total. A stacked chart adds series together, while a standard Area chart overlays them. Choose the type that matches the intended interpretation.
- Tile labels are hard to read. Treemaps have limited room for text, especially in small rectangles. Reduce the number of categories, group small items, or choose a bar chart with readable labels.
Frequently Asked Questions
Does Excel have a Square Area chart?
No. Excel has Area chart types and Treemap charts, but no built-in chart type named Square Area. The phrase usually means either a square-shaped Area chart frame or a chart made from value-sized tiles.
How do I make an Area chart square in Excel?
Select the chart’s outer border, open Format Chart Area, then go to Size & Properties and set matching height and width. The plot area may still be rectangular because the title, legend, and axes occupy space.
Is a Treemap the same as a square area chart?
No. A Treemap uses rectangular tiles whose areas correspond to values, often organized by hierarchy. The tiles are not necessarily square, and the chart is separate from Excel’s Area chart type.
Which chart is best for showing percentages as squares?
A waffle-style grid is often the closest fit: each equal cell represents a fixed fraction of the total. Excel has no dedicated waffle chart button, so the grid is typically made with formatted worksheet cells or another custom construction.
Can I use an Area chart for categories that are not dates?
Yes, Excel can plot text categories, but the connecting shape suggests an ordered sequence. For unrelated groups or a ranking, a bar or column chart is often clearer.
Related
- Excel Strikethrough Shortcut: Fast Ways to Cross Out Text
- Compare Two Excel Spreadsheets Quickly: Best Methods
- Shade Every Other Row in Excel: Quick, Reliable Methods
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Payment Chart: Build a Loan Schedule and GraphAn Excel payment chart is usually a loan amortization schedule paired with a graph showing how payments are…
- How to Refresh a Visio Org Chart from ExcelIf your Visio org chart is linked to an Excel workbook, open the diagram in Visio for Windows…
- How to Sort an Excel Pie Chart from Largest to SmallestTo sort an Excel pie chart from largest to smallest, sort the chart’s source data by its value…
- Interactive Excel Dashboard: How to Build OneYes. An interactive Excel dashboard is a worksheet that lets people explore key figures by changing filters or…
- Conditional Formatting Bar Chart in Excel: How It WorksTo make a bar chart inside Excel cells, select the values, then choose Home > Conditional Formatting >…
- Excel Pivot Tables: How to Create and Use ThemTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in your data, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.