Question: Using the data on the DrugUseByAge worksheet create a PivotTable to show the legal drug use by age. Insert the PivotTable on the LegalDrugs worksheet.

Using the data on the DrugUseByAge worksheet create a PivotTable to show the "legal" drug use by age.
Insert the PivotTable on the LegalDrugs worksheet.
Place age as the row labels.
Use an appropriate presentation of the alcohol-use, sedative-use, stimulant-use, tranquilizer-use, pain-reliever-use, oxycontin-use fields as the PivotTable values to display the total legal drug use by age.
Create a PivotChart on the LegalDrugs worksheet based on the PivotTable.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!