Blocks charts in Excel for Office 365

The Tip of the Night for November 1, 2021 discussed how to create block charts in Excel. Don't miss that the Office 365 version of Excel includes an option to automatically create block charts or tree maps.



Select a data range and then on the Insert tab of the ribbon, select Maps . . . More Map Charts, and select Treemap. The parts that compromise the full block are proportionally sized based on the values entered in the chart.