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.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

The total area under the curve is equal to 100% of respondents, but we are most interested in where respondents fall along the horizontal axis. In other static versions of this chart in the report, we ...