Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - working with pivot charts

This video tutorial guides viewers through an exercise on creating and formatting pivot charts. It begins with filtering data for specific categories, followed by creating a bar chart. The tutorial then covers formatting aspects such as hiding field labels, moving the legend, adding data labels, and adjusting font colors. Finally, it instructs on setting a chart title and changing the chart's color palette.

What is the first step in the exercise involving the pivot table?

• Create a pie chart

• Filter the data for specific categories

• Add data labels

• Change the chart color

Which type of chart is recommended to be used after filtering the data?

• Line chart

• Scatter plot

• Pie chart

• Bar chart

What should be done to the field labels on the pivot chart?

• Enlarge them

• Change their color

• Hide them

• Move them to the bottom

Where should the legend be positioned on the pivot chart?

• At the bottom

• On the left

• On the right

• At the top

What is the final color scheme to be applied to the chart?

• Vibrant Tones

• Pastel Shades

• Colourful Palette 3

• Monochrome