These instructions explain how to create a chart that displays the top-ten EMEA Countries by Sales, which requires using a filter to determine the top-ten sales regions by sales and creating a chart to display the data.
- Filter the table to display the top-ten countries by sales by right-clicking on the Country header, then selecting Top 10, etc.
The Numeric Filter dialog box appears. Leave the default settings then click OK.
- Switch the format of the report by clicking the Chart type drop-down arrow then select Stacked Column.
A stacked column chart appears and displays only the top-ten EMEA countries by sorted sales.