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 ...

Type in the interval that you want to use for the X-axis labels. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern.

This article discusses how to add a secondary axis to an existing chart and how to create a new chart with a secondary axis in Excel.

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

Making a floating bar chart in Microsoft Excel is a great way to visually represent distribution between entities. Susan Harkins will show you how.