, according to the data in this work are to use DSUM function for data aggregation, and on this basis in this worksheet to make a as shown in the figure below "different year, regional order amount or freight fee total" bar chart, a list box is placed on the graph to select the "orders" or "freight charge", graphics immediately reflect the European Union and non-european union region by the annual order amount summary or freight charges collect, (non-eu countries refers to the sum of all the countries in addition to the European Union's)