138k views
5 votes
Alex wants another way to compare the editing projects by level, but not by group. Collapse the outline in the Editing Projects PivotTable to display the Level names and to hide the Group IDs. Insert a PivotChart based on the Editing Projects PivotTable using the Stacked Column chart type. Resize and reposition the PivotChart so that the upper- left corner is located within cell A12 and the lower-right corner is located within cell F25. Change the PivotChart colors to Monochromatic Palette 5 to coordinate with the PivotTable.​

User Woxxy
by
8.5k points

1 Answer

6 votes


\rm answer

This activity appears to be related to using Microsoft Excel to create a PivotTable and PivotChart for comparing editing projects by level. The instructions involve collapsing the outline in the Editing Projects PivotTable to display the Level names and hiding the Group IDs. Then, a PivotChart is inserted based on the Editing Projects PivotTable using the Stacked Column chart type. The PivotChart is resized and repositioned to fit within specific cells, and its colors are changed to match the PivotTable using the Monochromatic Palette 5.

Overall, this activity is likely part of a larger task or project that involves analyzing and visualizing data using Excel. It demonstrates how to use PivotTables and PivotCharts to summarize and compare large data sets, and how to customize the appearance of these visualizations to make them more useful and visually appealing.

User Muzafarow
by
8.3k points