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.