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.

Excel usually does a good job second-guessing me when it chooses the scale for an axis on a chart. But sometimes, to better focus some data, I need to adjust that scale, and that’s when I run into ...