Pivot tables
Finally, we have reached the final topic of MySQL for Excel – pivot tables.
Pivot tables allow you to analyze your data by providing options to add different fields and values to a table, perform a multitude of mathematical operations on the data, and filter the data, both horizontally and vertically. Pivot tables are a powerful tool for analyzing data and preparing charts and graphs.
In this exercise, we will be importing data related to album sales and preparing it for display in a chart.
Exercise 12.07 – album sales
In this exercise, we will import some data from MySQL and create a pivot table with it. We will then add a chart to visualize the data:
- Click on the Pivot Tables worksheet tab. A blank sheet will be displayed:
Figure 12.33 – Click on the Pivot Tables worksheet tab
- Click on the A1 cell and type
Album Sales - Pivot Data, change the font size for the cell to 18 points, and make the...
