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.

Pie charts are unique among the types of graphs Excel can make because they only work with limited sets of data. Unlike bar charts and line charts, two or more pie charts do not combine easily ...

An icon in the shape of a lightning bolt. Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns ...