Treemaps are useful for showing hierarchy, patterns ... After you have finished creating your charts, add a dashboard to your Excel workbook to display the most important data in one place.