How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

In the Quick Layout group, there are 11 layouts, namely: Layout 1: Layout 1 shows the following elements: Chart Title, Legend (Right), Horizontal Axis, Vertical Axis, and Major Gridlines.

Naming Basics Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis.

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.