Question

A dataset contains three columns of data: Year, Month, and Sales Dollars. The Year column contains two years of data. A PivotChart will be created using the column chart type. The chart will show the sales dollars for each month. For each month, there will be two bars to represent each year of sales dollars. To create this chart, the Sales Dollars field must be dragged into which of the following areas? • VALUES O LEGEND O ROWS O FILTER AXIS

          A dataset contains three columns of data: Year, Month, and Sales Dollars.
The Year column contains two years of data. A PivotChart will be created
using the column chart type. The chart will show the sales dollars for each
month. For each month, there will be two bars to represent each year of
sales dollars. To create this chart, the Sales Dollars field must be dragged
into which of the following areas?
• VALUES
O LEGEND
O ROWS
O FILTER
AXIS

A dataset contains three columns of data: Year, Month, and Sales Dollars.
The Year column contains two years of data. A PivotChart will be created
using the column chart type. The chart will show the sales dollars for each
month. For each month, there will be two bars to represent each year of
sales dollars. To create this chart, the Sales Dollars field must be dragged
into which of the following areas?
• VALUES
O LEGEND
O ROWS
O FILTER
AXIS

Added by Pilar G.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Yujie Wang

06/04/2022

Step 1

So, we need to create a PivotTable using the given dataset. Show more…

Show all steps

Thanks for your feedback!

A dataset contains three columns of data: Year, Month, and Sales Dollars. The Year column contains two years of data. A PivotChart will be created using the column chart type. The chart will show the sales dollars for each month. For each month, there will be two bars to represent each year of sales dollars. To create this chart, the Sales Dollars field must be dragged into which of the following areas? VALUES LEGEND ROWS FILTER AXIS