Using a two-sided graph solves this dilemma by displaying the two series in relation to two different vertical scales, one on each side of the graph.

Creating compelling and professional visuals and graphs in Excel requires both a clear understanding of your data and the ability to use Excel’s powerful charting tools effectively.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.