1. Highlight the data you want to use for your Treemap.
  2. Click the Insert tab.
  3. Click the Insert Hierarchy button > Treemap. Excel will create and insert a Treemap chart into your spreadsheet.
  4. Double-click the chart to format it. You can apply a chart style, for example, edit the chart title, select a different color scheme, and so on. When your data is logically categorized and ordered, you can use a Treemap to easily find patterns in that information.

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special