DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column chart
|
|
|
Combo chart
|
|
|
Line with markers chart
|
|
|
Area chart
|
Detailed explanation-1: -Combo charts are a great choice: when you have a line chart and a column chart with the same X axis. to compare multiple measures with different value ranges.
Detailed explanation-2: -Dual axes are useful for analyzing two measures with different scales. To add a measure as a dual axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.
Detailed explanation-3: -A dual axis chart (also called a multiple axes chart) uses two axes to easily illustrate the relationships between two variables with different magnitudes and scales of measurement. The relationship between two variables is referred to as correlation.
Detailed explanation-4: -Dual-axis combination charts, or Combo Charts, are an effective chart type for showing related information while saving real estate by combining views. This chart type is created with one shared axis, such as an X-axis for date, and two separate axes, such as Y-axes for two different measures.