The values are plotted across the y-axis and the x-axis is used to mark the progression. In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread ...

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.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.