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.

Stacked charts in Microsoft Excel are a practical way to display three or more data series. A clustered chart is very similar to a stacked chart, and displays clustered columns that compare values ...

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.