The Sunburst chart is a much better visual chart for showing that. How to create a Treemap chart in Excel Follow the steps below to create a treemap chart in Excel: Select the data in your table.

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

Figure H Our new PivotChart. This type of chart provides a lot of information, and thanks to Excel’s two pivot objects, you won’t have to jump through hoops to produce it.

Making a floating bar chart in Microsoft Excel is a great way to visually represent distribution between entities. Susan Harkins will show you how.

This will cause Excel to display a number of Visio add-ins similar to what you see in Figure 2. [Click on image for larger view.] Figure 2: There are several Visio-related templates available for use.

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.