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 alcoholuse, sedativeuse, stimulantuse, tranquilizeruse, painrelieveruse, oxycontinuse 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
