e05h4Sociology

CREATE RELATIONSHIPS

The BOOKS table contains codes instead of discipline categories, and a new column contains editor IDs. You will create relationships between the BOOKS table and the DISCIPLINE and EDITOR tables to build a data model. Refer to Figure 5.44 as you complete Step 1.

a. Open e05h4Sociology and save it as e05h4Sociology_LastFirst. The Books sheet tab contains the BOOKS table. Notice that the discipline category names have been replaced with discipline codes in the first column. The third column contains codes that represent editor names.

b. Click the Disciplines sheet tab. The Disciplines sheet contains the DISCIPLINE table. Each discipline code and category name is listed only once. For example, FAM is the code for the Family discipline.

c. Click the Editors sheet tab. The Editors sheet contains the EDITOR table. Each editor is listed only once. For example, 101 is Melissa Hort.

d. Click the Books sheet tab and click cell A5.

e. Click the Data tab and click Relationships in the Data Tools group. The Manage Relationships dialog box opens.

f. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) arrow and select Discipline Code. • Click the Related Table arrow and select Worksheet Table: DISCIPLINE. • Click the Related Column (Primary) arrow and select Disc Code. • Click OK.

You created a relationship between the BOOKS and DISCIPLINE tables based on the common data, the discipline codes. The Manage Relationships dialog box now displays the relationship you created. You will now add a second relationship before closing the dialog box.

g. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) and select Editor ID. • Click the Related Table arrow and select Worksheet Table: EDITOR. • Click the Related Column (Primary) and select Editor ID. • Click OK. You created a relationship between the BOOKS and EDITOR tables based on the common data, the Editor IDs. The Manage Relationships dialog box now displays the relationship you created.

h. Click Close to close the Manage Relationships dialog box and save the workbook.

CREATE A PIVOTTABLE FROM RELATED TABLES Now that the BOOKS table is related to both the DISCIPLINE and EDITOR tables, you are ready to create a PivotTable using the three tables. Refer to Figure 5.45 as you complete Step 2.

a. Click within the dataset on the Books sheet, click the Insert tab, and then click PivotTable in the Tables group. The Create PivotTable dialog box opens with BOOKS as the selected Table/Range.

b. Click the Add this data to the Data Model check box to select it and click OK. Excel inserts Sheet1 with a blank PivotTable on the left side.

c. Click All at the top of the PivotTable Fields task pane. The PivotTable Fields task pane shows BOOKS, DISCIPLINE, and EDITOR table names.

d. Click BOOKS to display the fields in the BOOKS table, scroll through the fields, and then click the Total Book Sales check box to select it. The Total Book Sales field is added to the Values area.

e. Click Field Settings in the Active Field group on the Analyze tab to open the Value Field Settings dialog box and complete the following steps: • Click Number Format to open the Number Format dialog box. • Click Accounting in the Category list. • Change the Decimal places to 0. • Click OK in the Format Cells dialog box. • Click OK in the Value Field Settings dialog box. The value is formatted with Accounting Number Format with zero decimal places.

f. Click DISCIPLINE in the PivotTable Fields task pane to display the fields in the DISCIPLINE table and click the Discipline check box to select it. The Discipline field is added to the Rows area.

g. Scroll down and click EDITOR in the task pane to display the fields in the EDITOR table and click the Editor Last check box to select it. The Editor Last field is added below the Discipline field in the Rows area.

h. Double-click the Sheet1 sheet tab, type PivotTable, and then press Enter. Save the workbook.

CREATE A PIVOTCHART You want to create a PivotChart to depict the sales data by editor for the Family discipline. Refer to Figure 5.46 as you complete Step 3.

a. Right-click the PivotTable sheet tab, select Move or Copy, click the Create a copy check box to select it, and then click OK. You created a copy of the PivotTable so that you can preserve that PivotTable settings, modify the duplicate PivotTable, and then create a PivotChart based on the modified PivotTable.

b. Ensure the PivotTable (2) sheet tab is active, click PivotChart in the Tools group on the Analyze tab to open the Insert Chart dialog box, and then click OK. Excel creates a clustered column chart from the PivotTable.

c. Click the Design tab.

d. Click Change Chart Type in the Type group, click Pie, and then click OK. Save the workbook. You changed the chart type from a clustered column chart to a pie chart.

MODIFY THE PIVOTCHART

The PivotChart depicts too many data points. You will set a filter to display data for the Family discipline only. You will add a descriptive chart title and display slices from largest to smallest. Finally, you will display percentage data labels. Refer to Figure 5.47 as you complete Step 4.

a. Click the Discipline arrow within the PivotChart, click the Select All check box to deselect all disciplines, click the Family check box, and then click OK. This action filtered both the PivotChart and the PivotTable to display only Family discipline data.

b. Click Total in the chart title and type Family Discipline Book Sales. You changed the chart title to be more descriptive.

c. Click cell B5 in the PivotTable, click the Data tab, and then click Sort Largest to Smallest in the Sort & Filter group. This action sorts the values from largest to smallest in both the PivotTable and in the PivotChart.

d. Click the PivotChart, click Chart Elements on the right of the PivotChart, and then click the Data Labels check box to select it. You added data labels to the PivotChart.

e. Double-click a data label to display the Format Data Labels task pane, click the Value check box to deselect the values, click the Percentage check box, and then close the task pane.

f. Cut the PivotChart and paste it in cell C1. g. Save and close the file. Exit Excel. Based on your instructor’s directions, submit the following: e05h3Sociology_LastFirst e05h4Sociology_LastFirst

CREATE RELATIONSHIPS

The BOOKS table contains codes instead of discipline categories, and a new column contains editor IDs. You will create relationships between the BOOKS table and the DISCIPLINE and EDITOR tables to build a data model. Refer to Figure 5.44 as you complete Step 1.

a. Open e05h4Sociology and save it as e05h4Sociology_LastFirst. The Books sheet tab contains the BOOKS table. Notice that the discipline category names have been replaced with discipline codes in the first column. The third column contains codes that represent editor names.

b. Click the Disciplines sheet tab. The Disciplines sheet contains the DISCIPLINE table. Each discipline code and category name is listed only once. For example, FAM is the code for the Family discipline.

c. Click the Editors sheet tab. The Editors sheet contains the EDITOR table. Each editor is listed only once. For example, 101 is Melissa Hort.

d. Click the Books sheet tab and click cell A5.

e. Click the Data tab and click Relationships in the Data Tools group. The Manage Relationships dialog box opens.

f. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) arrow and select Discipline Code. • Click the Related Table arrow and select Worksheet Table: DISCIPLINE. • Click the Related Column (Primary) arrow and select Disc Code. • Click OK.

You created a relationship between the BOOKS and DISCIPLINE tables based on the common data, the discipline codes. The Manage Relationships dialog box now displays the relationship you created. You will now add a second relationship before closing the dialog box.

g. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) and select Editor ID. • Click the Related Table arrow and select Worksheet Table: EDITOR. • Click the Related Column (Primary) and select Editor ID. • Click OK. You created a relationship between the BOOKS and EDITOR tables based on the common data, the Editor IDs. The Manage Relationships dialog box now displays the relationship you created.

h. Click Close to close the Manage Relationships dialog box and save the workbook.

CREATE A PIVOTTABLE FROM RELATED TABLES Now that the BOOKS table is related to both the DISCIPLINE and EDITOR tables, you are ready to create a PivotTable using the three tables. Refer to Figure 5.45 as you complete Step 2.

a. Click within the dataset on the Books sheet, click the Insert tab, and then click PivotTable in the Tables group. The Create PivotTable dialog box opens with BOOKS as the selected Table/Range.

b. Click the Add this data to the Data Model check box to select it and click OK. Excel inserts Sheet1 with a blank PivotTable on the left side.

c. Click All at the top of the PivotTable Fields task pane. The PivotTable Fields task pane shows BOOKS, DISCIPLINE, and EDITOR table names.

d. Click BOOKS to display the fields in the BOOKS table, scroll through the fields, and then click the Total Book Sales check box to select it. The Total Book Sales field is added to the Values area.

e. Click Field Settings in the Active Field group on the Analyze tab to open the Value Field Settings dialog box and complete the following steps: • Click Number Format to open the Number Format dialog box. • Click Accounting in the Category list. • Change the Decimal places to 0. • Click OK in the Format Cells dialog box. • Click OK in the Value Field Settings dialog box. The value is formatted with Accounting Number Format with zero decimal places.

f. Click DISCIPLINE in the PivotTable Fields task pane to display the fields in the DISCIPLINE table and click the Discipline check box to select it. The Discipline field is added to the Rows area.

g. Scroll down and click EDITOR in the task pane to display the fields in the EDITOR table and click the Editor Last check box to select it. The Editor Last field is added below the Discipline field in the Rows area.

h. Double-click the Sheet1 sheet tab, type PivotTable, and then press Enter. Save the workbook.

CREATE A PIVOTCHART You want to create a PivotChart to depict the sales data by editor for the Family discipline. Refer to Figure 5.46 as you complete Step 3.

a. Right-click the PivotTable sheet tab, select Move or Copy, click the Create a copy check box to select it, and then click OK. You created a copy of the PivotTable so that you can preserve that PivotTable settings, modify the duplicate PivotTable, and then create a PivotChart based on the modified PivotTable.

b. Ensure the PivotTable (2) sheet tab is active, click PivotChart in the Tools group on the Analyze tab to open the Insert Chart dialog box, and then click OK. Excel creates a clustered column chart from the PivotTable.

c. Click the Design tab.

d. Click Change Chart Type in the Type group, click Pie, and then click OK. Save the workbook. You changed the chart type from a clustered column chart to a pie chart.

MODIFY THE PIVOTCHART

The PivotChart depicts too many data points. You will set a filter to display data for the Family discipline only. You will add a descriptive chart title and display slices from largest to smallest. Finally, you will display percentage data labels. Refer to Figure 5.47 as you complete Step 4.

a. Click the Discipline arrow within the PivotChart, click the Select All check box to deselect all disciplines, click the Family check box, and then click OK. This action filtered both the PivotChart and the PivotTable to display only Family discipline data.

b. Click Total in the chart title and type Family Discipline Book Sales. You changed the chart title to be more descriptive.

c. Click cell B5 in the PivotTable, click the Data tab, and then click Sort Largest to Smallest in the Sort & Filter group. This action sorts the values from largest to smallest in both the PivotTable and in the PivotChart.

d. Click the PivotChart, click Chart Elements on the right of the PivotChart, and then click the Data Labels check box to select it. You added data labels to the PivotChart.

e. Double-click a data label to display the Format Data Labels task pane, click the Value check box to deselect the values, click the Percentage check box, and then close the task pane.

f. Cut the PivotChart and paste it in cell C1. g. Save and close the file. Exit Excel. Based on your instructor’s directions, submit the following: e05h3Sociology_LastFirst e05h4Sociology_LastFirst

CREATE RELATIONSHIPS

The BOOKS table contains codes instead of discipline categories, and a new column contains editor IDs. You will create relationships between the BOOKS table and the DISCIPLINE and EDITOR tables to build a data model. Refer to Figure 5.44 as you complete Step 1.

a. Open e05h4Sociology and save it as e05h4Sociology_LastFirst. The Books sheet tab contains the BOOKS table. Notice that the discipline category names have been replaced with discipline codes in the first column. The third column contains codes that represent editor names.

b. Click the Disciplines sheet tab. The Disciplines sheet contains the DISCIPLINE table. Each discipline code and category name is listed only once. For example, FAM is the code for the Family discipline.

c. Click the Editors sheet tab. The Editors sheet contains the EDITOR table. Each editor is listed only once. For example, 101 is Melissa Hort.

d. Click the Books sheet tab and click cell A5.

e. Click the Data tab and click Relationships in the Data Tools group. The Manage Relationships dialog box opens.

f. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) arrow and select Discipline Code. • Click the Related Table arrow and select Worksheet Table: DISCIPLINE. • Click the Related Column (Primary) arrow and select Disc Code. • Click OK.

You created a relationship between the BOOKS and DISCIPLINE tables based on the common data, the discipline codes. The Manage Relationships dialog box now displays the relationship you created. You will now add a second relationship before closing the dialog box.

g. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) and select Editor ID. • Click the Related Table arrow and select Worksheet Table: EDITOR. • Click the Related Column (Primary) and select Editor ID. • Click OK. You created a relationship between the BOOKS and EDITOR tables based on the common data, the Editor IDs. The Manage Relationships dialog box now displays the relationship you created.

h. Click Close to close the Manage Relationships dialog box and save the workbook.

CREATE A PIVOTTABLE FROM RELATED TABLES Now that the BOOKS table is related to both the DISCIPLINE and EDITOR tables, you are ready to create a PivotTable using the three tables. Refer to Figure 5.45 as you complete Step 2.

a. Click within the dataset on the Books sheet, click the Insert tab, and then click PivotTable in the Tables group. The Create PivotTable dialog box opens with BOOKS as the selected Table/Range.

b. Click the Add this data to the Data Model check box to select it and click OK. Excel inserts Sheet1 with a blank PivotTable on the left side.

c. Click All at the top of the PivotTable Fields task pane. The PivotTable Fields task pane shows BOOKS, DISCIPLINE, and EDITOR table names.

d. Click BOOKS to display the fields in the BOOKS table, scroll through the fields, and then click the Total Book Sales check box to select it. The Total Book Sales field is added to the Values area.

e. Click Field Settings in the Active Field group on the Analyze tab to open the Value Field Settings dialog box and complete the following steps: • Click Number Format to open the Number Format dialog box. • Click Accounting in the Category list. • Change the Decimal places to 0. • Click OK in the Format Cells dialog box. • Click OK in the Value Field Settings dialog box. The value is formatted with Accounting Number Format with zero decimal places.

f. Click DISCIPLINE in the PivotTable Fields task pane to display the fields in the DISCIPLINE table and click the Discipline check box to select it. The Discipline field is added to the Rows area.

g. Scroll down and click EDITOR in the task pane to display the fields in the EDITOR table and click the Editor Last check box to select it. The Editor Last field is added below the Discipline field in the Rows area.

h. Double-click the Sheet1 sheet tab, type PivotTable, and then press Enter. Save the workbook.

CREATE A PIVOTCHART You want to create a PivotChart to depict the sales data by editor for the Family discipline. Refer to Figure 5.46 as you complete Step 3.

a. Right-click the PivotTable sheet tab, select Move or Copy, click the Create a copy check box to select it, and then click OK. You created a copy of the PivotTable so that you can preserve that PivotTable settings, modify the duplicate PivotTable, and then create a PivotChart based on the modified PivotTable.

b. Ensure the PivotTable (2) sheet tab is active, click PivotChart in the Tools group on the Analyze tab to open the Insert Chart dialog box, and then click OK. Excel creates a clustered column chart from the PivotTable.

c. Click the Design tab.

d. Click Change Chart Type in the Type group, click Pie, and then click OK. Save the workbook. You changed the chart type from a clustered column chart to a pie chart.

MODIFY THE PIVOTCHART

The PivotChart depicts too many data points. You will set a filter to display data for the Family discipline only. You will add a descriptive chart title and display slices from largest to smallest. Finally, you will display percentage data labels. Refer to Figure 5.47 as you complete Step 4.

a. Click the Discipline arrow within the PivotChart, click the Select All check box to deselect all disciplines, click the Family check box, and then click OK. This action filtered both the PivotChart and the PivotTable to display only Family discipline data.

b. Click Total in the chart title and type Family Discipline Book Sales. You changed the chart title to be more descriptive.

c. Click cell B5 in the PivotTable, click the Data tab, and then click Sort Largest to Smallest in the Sort & Filter group. This action sorts the values from largest to smallest in both the PivotTable and in the PivotChart.

d. Click the PivotChart, click Chart Elements on the right of the PivotChart, and then click the Data Labels check box to select it. You added data labels to the PivotChart.

e. Double-click a data label to display the Format Data Labels task pane, click the Value check box to deselect the values, click the Percentage check box, and then close the task pane.

f. Cut the PivotChart and paste it in cell C1. g. Save and close the file. Exit Excel. Based on your instructor’s directions, submit the following: e05h3Sociology_LastFirst e05h4Sociology_LastFirst

CREATE RELATIONSHIPS CREATE RELATIONSHIPS

The BOOKS table contains codes instead of discipline categories, and a new column contains editor IDs. You will create relationships between the BOOKS table and the DISCIPLINE and EDITOR tables to build a data model. Refer to Figure 5.44 as you complete Step 1. The BOOKS table contains codes instead of discipline categories, and a new column contains editor IDs. You will create relationships between the BOOKS table and the DISCIPLINE and EDITOR tables to build a data model. Refer to Figure 5.44 as you complete Step 1.

a. Open e05h4Sociology and save it as e05h4Sociology_LastFirst. The Books sheet tab contains the BOOKS table. Notice that the discipline category names have been replaced with discipline codes in the first column. The third column contains codes that represent editor names. a. Open e05h4Sociology and save it as e05h4Sociology_LastFirst. The Books sheet tab contains the BOOKS table. Notice that the discipline category names have been replaced with discipline codes in the first column. The third column contains codes that represent editor names.

b. Click the Disciplines sheet tab. The Disciplines sheet contains the DISCIPLINE table. Each discipline code and category name is listed only once. For example, FAM is the code for the Family discipline. b. Click the Disciplines sheet tab. The Disciplines sheet contains the DISCIPLINE table. Each discipline code and category name is listed only once. For example, FAM is the code for the Family discipline.

c. Click the Editors sheet tab. The Editors sheet contains the EDITOR table. Each editor is listed only once. For example, 101 is Melissa Hort. c. Click the Editors sheet tab. The Editors sheet contains the EDITOR table. Each editor is listed only once. For example, 101 is Melissa Hort.

d. Click the Books sheet tab and click cell A5. d. Click the Books sheet tab and click cell A5.

e. Click the Data tab and click Relationships in the Data Tools group. The Manage Relationships dialog box opens. e. Click the Data tab and click Relationships in the Data Tools group. The Manage Relationships dialog box opens.

f. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) arrow and select Discipline Code. • Click the Related Table arrow and select Worksheet Table: DISCIPLINE. • Click the Related Column (Primary) arrow and select Disc Code. • Click OK. f. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) arrow and select Discipline Code. • Click the Related Table arrow and select Worksheet Table: DISCIPLINE. • Click the Related Column (Primary) arrow and select Disc Code. • Click OK.

You created a relationship between the BOOKS and DISCIPLINE tables based on the common data, the discipline codes. The Manage Relationships dialog box now displays the relationship you created. You will now add a second relationship before closing the dialog box. You created a relationship between the BOOKS and DISCIPLINE tables based on the common data, the discipline codes. The Manage Relationships dialog box now displays the relationship you created. You will now add a second relationship before closing the dialog box.

g. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) and select Editor ID. • Click the Related Table arrow and select Worksheet Table: EDITOR. • Click the Related Column (Primary) and select Editor ID. • Click OK. You created a relationship between the BOOKS and EDITOR tables based on the common data, the Editor IDs. The Manage Relationships dialog box now displays the relationship you created. g. Click New to open the Create Relationship dialog box and do the following: • Click the Table arrow and select Worksheet Table: BOOKS. • Click the Column (Foreign) and select Editor ID. • Click the Related Table arrow and select Worksheet Table: EDITOR. • Click the Related Column (Primary) and select Editor ID. • Click OK. You created a relationship between the BOOKS and EDITOR tables based on the common data, the Editor IDs. The Manage Relationships dialog box now displays the relationship you created.

h. Click Close to close the Manage Relationships dialog box and save the workbook. h. Click Close to close the Manage Relationships dialog box and save the workbook.

CREATE A PIVOTTABLE FROM RELATED TABLES Now that the BOOKS table is related to both the DISCIPLINE and EDITOR tables, you are ready to create a PivotTable using the three tables. Refer to Figure 5.45 as you complete Step 2. CREATE A PIVOTTABLE FROM RELATED TABLES Now that the BOOKS table is related to both the DISCIPLINE and EDITOR tables, you are ready to create a PivotTable using the three tables. Refer to Figure 5.45 as you complete Step 2.

a. Click within the dataset on the Books sheet, click the Insert tab, and then click PivotTable in the Tables group. The Create PivotTable dialog box opens with BOOKS as the selected Table/Range. a. Click within the dataset on the Books sheet, click the Insert tab, and then click PivotTable in the Tables group. The Create PivotTable dialog box opens with BOOKS as the selected Table/Range.

b. Click the Add this data to the Data Model check box to select it and click OK. Excel inserts Sheet1 with a blank PivotTable on the left side. b. Click the Add this data to the Data Model check box to select it and click OK. Excel inserts Sheet1 with a blank PivotTable on the left side.

c. Click All at the top of the PivotTable Fields task pane. The PivotTable Fields task pane shows BOOKS, DISCIPLINE, and EDITOR table names. c. Click All at the top of the PivotTable Fields task pane. The PivotTable Fields task pane shows BOOKS, DISCIPLINE, and EDITOR table names.

d. Click BOOKS to display the fields in the BOOKS table, scroll through the fields, and then click the Total Book Sales check box to select it. The Total Book Sales field is added to the Values area. d. Click BOOKS to display the fields in the BOOKS table, scroll through the fields, and then click the Total Book Sales check box to select it. The Total Book Sales field is added to the Values area.

e. Click Field Settings in the Active Field group on the Analyze tab to open the Value Field Settings dialog box and complete the following steps: • Click Number Format to open the Number Format dialog box. • Click Accounting in the Category list. • Change the Decimal places to 0. • Click OK in the Format Cells dialog box. • Click OK in the Value Field Settings dialog box. The value is formatted with Accounting Number Format with zero decimal places. e. Click Field Settings in the Active Field group on the Analyze tab to open the Value Field Settings dialog box and complete the following steps: • Click Number Format to open the Number Format dialog box. • Click Accounting in the Category list. • Change the Decimal places to 0. • Click OK in the Format Cells dialog box. • Click OK in the Value Field Settings dialog box. The value is formatted with Accounting Number Format with zero decimal places.

f. Click DISCIPLINE in the PivotTable Fields task pane to display the fields in the DISCIPLINE table and click the Discipline check box to select it. The Discipline field is added to the Rows area. f. Click DISCIPLINE in the PivotTable Fields task pane to display the fields in the DISCIPLINE table and click the Discipline check box to select it. The Discipline field is added to the Rows area.

g. Scroll down and click EDITOR in the task pane to display the fields in the EDITOR table and click the Editor Last check box to select it. The Editor Last field is added below the Discipline field in the Rows area. g. Scroll down and click EDITOR in the task pane to display the fields in the EDITOR table and click the Editor Last check box to select it. The Editor Last field is added below the Discipline field in the Rows area.

h. Double-click the Sheet1 sheet tab, type PivotTable, and then press Enter. Save the workbook. h. Double-click the Sheet1 sheet tab, type PivotTable, and then press Enter. Save the workbook.

CREATE A PIVOTCHART You want to create a PivotChart to depict the sales data by editor for the Family discipline. Refer to Figure 5.46 as you complete Step 3. CREATE A PIVOTCHART You want to create a PivotChart to depict the sales data by editor for the Family discipline. Refer to Figure 5.46 as you complete Step 3.

a. Right-click the PivotTable sheet tab, select Move or Copy, click the Create a copy check box to select it, and then click OK. You created a copy of the PivotTable so that you can preserve that PivotTable settings, modify the duplicate PivotTable, and then create a PivotChart based on the modified PivotTable. a. Right-click the PivotTable sheet tab, select Move or Copy, click the Create a copy check box to select it, and then click OK. You created a copy of the PivotTable so that you can preserve that PivotTable settings, modify the duplicate PivotTable, and then create a PivotChart based on the modified PivotTable.

b. Ensure the PivotTable (2) sheet tab is active, click PivotChart in the Tools group on the Analyze tab to open the Insert Chart dialog box, and then click OK. Excel creates a clustered column chart from the PivotTable. b. Ensure the PivotTable (2) sheet tab is active, click PivotChart in the Tools group on the Analyze tab to open the Insert Chart dialog box, and then click OK. Excel creates a clustered column chart from the PivotTable.

c. Click the Design tab. c. Click the Design tab.

d. Click Change Chart Type in the Type group, click Pie, and then click OK. Save the workbook. You changed the chart type from a clustered column chart to a pie chart. d. Click Change Chart Type in the Type group, click Pie, and then click OK. Save the workbook. You changed the chart type from a clustered column chart to a pie chart.

MODIFY THE PIVOTCHART MODIFY THE PIVOTCHART

The PivotChart depicts too many data points. You will set a filter to display data for the Family discipline only. You will add a descriptive chart title and display slices from largest to smallest. Finally, you will display percentage data labels. Refer to Figure 5.47 as you complete Step 4. The PivotChart depicts too many data points. You will set a filter to display data for the Family discipline only. You will add a descriptive chart title and display slices from largest to smallest. Finally, you will display percentage data labels. Refer to Figure 5.47 as you complete Step 4.

a. Click the Discipline arrow within the PivotChart, click the Select All check box to deselect all disciplines, click the Family check box, and then click OK. This action filtered both the PivotChart and the PivotTable to display only Family discipline data. a. Click the Discipline arrow within the PivotChart, click the Select All check box to deselect all disciplines, click the Family check box, and then click OK. This action filtered both the PivotChart and the PivotTable to display only Family discipline data.

b. Click Total in the chart title and type Family Discipline Book Sales. You changed the chart title to be more descriptive. b. Click Total in the chart title and type Family Discipline Book Sales. You changed the chart title to be more descriptive.

c. Click cell B5 in the PivotTable, click the Data tab, and then click Sort Largest to Smallest in the Sort & Filter group. This action sorts the values from largest to smallest in both the PivotTable and in the PivotChart. c. Click cell B5 in the PivotTable, click the Data tab, and then click Sort Largest to Smallest in the Sort & Filter group. This action sorts the values from largest to smallest in both the PivotTable and in the PivotChart.

d. Click the PivotChart, click Chart Elements on the right of the PivotChart, and then click the Data Labels check box to select it. You added data labels to the PivotChart. d. Click the PivotChart, click Chart Elements on the right of the PivotChart, and then click the Data Labels check box to select it. You added data labels to the PivotChart.

e. Double-click a data label to display the Format Data Labels task pane, click the Value check box to deselect the values, click the Percentage check box, and then close the task pane. e. Double-click a data label to display the Format Data Labels task pane, click the Value check box to deselect the values, click the Percentage check box, and then close the task pane.

f. Cut the PivotChart and paste it in cell C1. g. Save and close the file. Exit Excel. Based on your instructor’s directions, submit the following: e05h3Sociology_LastFirst e05h4Sociology_LastFirst f. Cut the PivotChart and paste it in cell C1. g. Save and close the file. Exit Excel. Based on your instructor’s directions, submit the following: e05h3Sociology_LastFirst e05h4Sociology_LastFirst

Answers

Related Questions

Computer Science : Cloud computing ASM...

Regional Gardens Ltd is a company that runs a number of related gardening enterprises. It has a large display garden that it opens for public inspecti...

Communications : Ethics of Friendship...

This is a very short paper but I am paying you extra for it so you can buy/rent the ebook for $7 (90 day rental). Technically you get paid $13. This w...

Algebra : piece wise functions...

All type 2 residential users pay a facility charge of $11.00Additional fees include :12.1 cents per kilowatt hour for all usage up to and including 60...

Business : 14 finance problems...

Please help answer these questions. I found that they have similar problems online (google), but they are not the exact problems (different numbers) I...

History : Us and global economics...

1.  What significant events were occurring in England and North America at the time that The Wealth of Nations was written?(3 points)2.  What was Ad...

Humanities : Judgment Day: Intelligent Design On...

Judgment Day: Intelligent Design On Trial (creationism vs evolution) Please watch the video and write a reflection paper of about 1-2 pages on your th...

Art & Design : Wk 7...

For this week, answer all three of the following questions. Cite at least one example in your response for each question. You should reference your bo...

Art & Design : Final Project...

For your final project, you will complete a virtual art museum visit and thoroughly discuss two to four works. Please pay close attention to the follo...

Business Finance : Kudler Fine Foods management D...

Please do not bid if you are asking for more than $15.0% PLAGIARISM!! 0 GRAMMAR ERRORS!! NO PAST DUE, PLEASE!! Before data may be automated, it must b...

Business Finance : Understand financial statement...

I need help completing the following-please ensure you have completed something like this in the past.Part 1Complete an 1120 based on the attached - ...

Science : volume and mass physics questions help...

1- If a box has a length of 10.0 cm, a width of 20.0 cm, and a height of 5.00 cm, then what is its volume in m^3?2- What is the difference between 3.1...

Computer Science : java programme...

1.  Suppose a class GroceryBill keeps track of a list of items being purchased at a market: public GroceryBill(Employee clerk)  Constructs a grocer...

Computer Science : CMIS 330 SRS Assignment 1...

You have been asked to lead a software development team to build a system fulfilling the Statement of Need below. Your team is employed by a small com...

Programming : Technologies and Methodologies Eval...

Consider information management risks to include cybercrime and cyber-related crimes.Write a 3- to 5-page evaluation of security technologies and me...

Science : MICROBIOLOGY RESEARCH HOMEWORK...

Research and select 1 oncovirus (a virus that is linked to the cause of cancer)... Include the following information:1. A brief overview of the virus...

Business Finance : Strategic Management in Dynami...

Primary Discussion Response is due by Wednesday (11:59:59pm Central), Peer Responses are due by Sunday (11:59:59pm Central).Primary Task Response: Wi...

Marketing : Strategic Management in Dynamic Envir...

Primary Discussion Response is due by Wednesday (11:59:59pm Central), Peer Responses are due by Sunday (11:59:59pm Central).Primary Task Response: Wi...

Algebra : math - algebra 2 so please help...

Given P(x) → -∞ as x→ + ∞ and P(x) → + ∞ as x → - ∞, which of the following could be true?P(x) = 5x4 - 8x3 + 3x2 - 2x - 7P(x)...

Social Science : Question HELP PLEASE...

Case Study #1, you would explore the topic of severe depression from the clinical psychology perspective. Research the chosen topic using scholarly r...

Computer Science : CIS-518 Assignment 3: Creating...

This assignment consists of two (2) sections: a test plan and a PowerPoint presentation. You must submit the two (2) sections as separate files for th...

Accounting : Additional funds needed if assets wer...

Refer to Problem 12-1. What would be the additional funds needed if the company’s year-end 2010 assets had been $4 million? Assume that all other nu...

Social Science : Social Science Question...

Photovoice is a method used to visually represent a concept or idea. When you use the method of photovoice to explain a phenomena, idea, or circumstan...

Social Science : Film Review...

In this final film review, I want you to describe and evaluate the film 'Minimalism: A Documentary About The Important Things" Describr in careful...

Business : Home Depot Business Plan...

I have a template of exactly what I have to add to my Group Project, which is a business plan on Home Depot. It is supposed to be 15 pages total and m...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it