Chart the Summary Data Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

Step 3: Microsoft Excel provides a convenient feature that allows you to select from a number of templates for the graph. Click the Insert tab and then select Recommended charts.

If you want to change the colors of your organizational chart, you can do so by selecting the graphic, returning to the Design section of the SmartArt toolbar and selecting Change Colors.

To create a bi-directional mirror bar chart in Excel, you will have to start with the Stacked Bar In the 2-D Bar section. Here are the detailed steps to be followed.

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.