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.

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.

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.

You’re ready to create the chart by basing it on the three-columns of data shown earlier in Figure A. To do so, select the entire data set B2:D16 and do the following: Click the Insert tab.

A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.