Combine Column bars for Revenue ($) with a secondary axis Line for Profit Margin (%) on a single chart.
When comparing Revenue ($200,000) vs Profit Margin (25%), placing 25% on a $200k axis makes the percentage invisible. A secondary axis scales both metrics perfectly.
5 questions on dual axes, scale mismatching, and series chart types