Resolve the need to visually compare positive and negative deviations in Excel by creating two-line charts with semi-transparent red area fills.