Which chart option adds a secondary axis to accommodate disparate data ranges?

• A. Primary Axis
• B. Trendline
• C. Secondary Axis
• D. Legend

Answer: (C)

When charting data that don’t share the same range, you need two value scales so both datasets can be read clearly. Adding a secondary axis provides a second Y-axis (usually on the right side) and lets one data series use the primary axis while another uses the secondary axis. This preserves the relative trends of each series without one scale dominating the chart.

To implement this, you typically select a data series and choose the option to plot it on a secondary axis, then adjust the axis labels so it’s clear which data belongs to which axis. It’s also good practice to use distinct colors and a clear legend so readers don’t misinterpret the comparison.

The other options won’t create a second scale: the primary axis is just the main axis for the chart, a trendline adds a statistical line for trend analysis, and a legend only labels the series without changing how data is scaled.