Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis. For example, in a chart that displays ...

For example, click "Column" and click the first thumbnail in the drop-down menu. Excel inserts a chart that does not yet track your data correctly. Right-click on the chart.

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.