By default, Excel summarizes your data by either summing or counting the items. To change the type of calculation that you want to use, execute the following steps.
If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.
Consider the type of graph you want to make. There are three basic types of graph that you can create in Excel, each of which works best for certain types of data:
Bar – Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of data.
Line – Displays one or more sets of data using horizontal lines. Best for showing growth or decline in data over time.
Pie – Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.