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.

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.