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.

How to Merge Cells in Excel On top of making a sheet’s layout look clean, combining cells can also help group related data. That way, you don’t have to stretch cells to show more information ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

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.