What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells Insert tab Charts group Insert Combo Chart symbol Create Custom Combo Chart Insert Chart dialog box All Charts Series 1 X (Chart type) Series 2 Y (Chart type) OK?
A) X - Scatter,Y - Stacked Bar
B) X - Clustered Column,Y - Line
C) X - Radar with Markers,Y - Area
D) X- Clustered Bar,Y- Stacked Line

Question

What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells > Insert tab > Charts group > Insert Combo Chart symbol > Create Custom Combo Chart > Insert Chart dialog box > All Charts > Series 1 > X (Chart type)> Series 2 > Y (Chart type)> OK?
A) X - Scatter,Y - Stacked Bar
B) X - Clustered Column,Y - Line
C) X - Radar with Markers,Y - Area
D) X- Clustered Bar,Y- Stacked Line

Quizplus · Accepted Answer

The question specifically mentions that we need to insert a Clustered Column - Line Combination chart. Therefore, the best choice would be to select Clustered Column as X and Line as Y. Option A and D do not include the required chart types, and option C is not relevant to the given requirement.

What Will You Select as X and Y in the Following