Question

the worksheet exam 7 of the workbook chart questions.xlsx contains two prices and for each price gives the demand for a drug. we would like to display price on the x - axis and demand on the y - axis. the chart displayed in the worksheet needs to be changed. which of the following actions would fix the chart? select the chart series and after choosing chart design select switch rows and columns. change the chart to a line chart. add data labels.

Explanation:

Step1: Analyze the problem

The goal is to display Price on X - axis and Demand on Y - axis. Currently, the chart may have wrong axis assignments.

Step2: Evaluate each option

• Option 1:

When we select the chart series and choose "Switch Rows and Columns" (in Chart Design), it can swap the data that is plotted on the X and Y axes. This is useful when the initial data arrangement for axes is incorrect.

• Option 2:

Changing the chart to a line chart only changes the visual representation style (e.g., from bar to line). It does not address the axis assignment problem.

• Option 3:

Adding data labels only adds labels to the data points (e.g., values on bars or points). It does not change the axis assignment.

Answer:

Select the chart series and after choosing Chart Design select Switch Rows and Columns.