A regional sales lead wants a single view that plots monthly revenue as columns and the running profit margin percentage as a line, with the two measures using independent vertical axes because their scales differ greatly. Which chart type meets this requirement?
- AA dual-axis combination chart with one measure as bars and the other as a line Correct
- BA stacked bar chart that layers both measures into a single set of columns
- CA pie chart split into slices for revenue and margin
- DA single-axis line chart drawing both measures against the same scale
Why A is correct: A dual-axis chart places two measures on separate, independently scaled vertical axes, and combining bar and line marks lets revenue and margin share one view despite their different ranges.
Why B is wrong: Stacking is tempting for combining two measures, but it forces both onto one shared axis and implies the parts sum to a total, which is wrong for a percentage and a currency value.
Why C is wrong: A pie chart shows parts of a whole at a single point in time and cannot display a monthly trend across two differently scaled measures.
Why D is wrong: Drawing both on one axis is the natural first attempt, but the percentage line would be flattened against the much larger revenue scale, defeating the comparison.