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.

Clustered Column -Line: This Chart type is used when you have mixed types of data.; Clustered Column -Line on Secondary Axis: This chart type is used when the chart’s range varies widely and has ...

Swap X and Y axes: Excel also has a built-in ... and choose the second combo chart option. This changes the chart ... Now we can clearly see the correlation between units sold and defect percentage.

Enable Chart Tool options by clicking anywhere within an Excel 2007 or 2010 chart whose information you want to modify. Click Design on the main menu, then Layout and finally, select Axis Title or ...

Select the chart elements (title, labels, axis text, etc.), then change the font. It’s a small change but it massively upgrades the chart’s personality. Add a Subtle Background ...