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 menu options cited below apply specifically to Excel 2016; while this chart can also be created in Excel 2013, 2010, and 2007, the menu options may be slightly different.) 1. Convert metrics data ...

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.