5 questions

Title ABC/123 Version X

1

Graphical Techniques Instructions

Instructions for Question 1

Step 1 : Select the entire table including the headings. Make sure you also select the headings (Projection TV, LCD TV, Plasma TV).

Step 2 : Click on the Insert tab on the top of Excel.

Step 3 : Click on the column chart dropdown.

Step 4 : Select 100% stacked column chart.

Step 5 : Make sure you get the legend. If you don't get the legend, then please go back to Step 1 above and select the titles AND the data.

Step 6 : Give a brief and sensible title to the chart.

Step 7 : Optional - Label your Y-axis. Make sure you have ($ thousands) as units.

Instructions for Question 2

Step 1 : Select the entire table including the headings.

Step 2 : Click on the Insert tab on the top of Excel.

Step 3 : Click on the Pie Chart option.

Step 4 : Once the pie chart gets displayed, right-click on the pie chart and select “Add Data Labels”.

Step 5 : You will see the numbers on the pieces of the pie chart. Right-click these numbers and select “Format Data Labels”.

Step 6 : Under “Format Data Labels”, check mark only the Category Name, Percentage, and Show Leader Lines. Uncheck the Value box.

Step 7 : Close the “Format Data Labels” box.

Step 8 : Delete the legend at the bottom of the pie chart.

Instructions for Question 3

Steps for creating a Pivot Table.

Step 1 : Click on any one rating.

Step 2 : Click on the Insert tab on the top of Excel.

Step 3 : Click on PivotTable to the left.

Step 4 : In the Create PivotTable window, click OK.

Step 5 : In the PivotTable fields, drag the Restaurant Ratings to Rows.

Step 6 : In the PivotTable fields, drag the Restaurant Ratings to Values.

Step 7 : Close the Pivot fields box on the right.

Step 8 : Right-click any number on the pivot table.

Step 9 : Click on Sort.

Step 10 : Click on From Largest to Smallest.

Step 11: Rename the columns.

Steps for creating a Pivot Bar Chart

Step 1 : Click anywhere inside the pivot table

Step 2 : On the right, click on PivotChart

Step 3 : Click on Column or Bar on the Insert Chart window.

Step 4 : Click OK to close the Insert Chart window.

Steps for creating a Pivot Pie Chart

Step 1 : Click anywhere inside the pivot table

Step 2: On the right, click on PivotChart

Step 3 : Click on Pie on the Insert Chart window.

Step 4: Click OK to close the Insert Chart window.

Step 5 : Right-click on the pie chart.

Step 6 : Select Add Data Labels.

Step 7 : Right-click on the numbers in the pieces of the pie.

Step 8: Select Format Data labels

Step 9: Check the Category and Percentage boxes.

Step 10 : Uncheck the Value box.

Instructions for Question 4

Step 1 : Select the entire table Make sure you select the headings too.

Step 2 : Click on the Insert tab on the Excel ribbon.

Step 3 : Click on the line chart.

Step 4 : The line chart should be plotted.

Copyright © XXXX by University of Phoenix. All rights reserved.