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.

How to Use Goal Seek in Excel Goal Seek is already built into Excel. It's under the Data tab, in the What-If Analysis menu. Let's walk through it with a simple example.