Hopefully some SDF users can use Eurostat themselves to show the world the massive amounts of money the EU makes from the car trade with China.
Getting this data from Eurostat:
Eurostat is a pretty tough and tricky website to use. Anyways, here's this data was obtained. Maybe experienced users can do things in a better way.
PART 1 -
Go to
.
Click "Available datasets" => "INTERNATIONAL TRADE" => "EU trade since 2002 by SITC (DS-059331)" => "New query."
PART 2 -
There will be a page with six tables: "REPORTER," "PARTNER," "PRODUCT," "FLOW," "PERIOD," and "INDICATORS."
Click the plus button above all six tables to present all the options. To remove options, highlight unwanted options and then do "
Shift + Double-Click".
If you make a mistake, you can click the plus button again to present all the options. (Hopefully this isn't confusing, because it took forever to figure this out.)
Select these options.
REPORTER | EU-European Union (AT-01/1995, BE-01/1958, BG-01/2007, CY-05/2004, CZ-05/2004, DE-01/1958, DK-01/1973, EE-05/2004, ES-01/1986, FI-01/1995, FR-01/1958, GB-01/1973->01/2020, GR-01/1981, HR-07/2013, HU-05/2004, IE-01/1973, IT-01/1958, LT-05/2004, LU-01/1958, LV-05/2004, MT-05/2004, NL-01/1958, PL-05/2004, PT-01/1986, RO-01/2007, SE-01/1995, SI-05/2004, SK-05/2004) |
PARTNER | CN-China
JP-Japan
KR-Korea
Republic of (South Korea)
MX-Mexico |
PRODUCT | 81-Motor cars and other motor vehicles principally designed for the transport of persons (other than motor vehicles for the transport of ten or more persons, including the driver), including station-wagons and racing cars |
FLOW | 1-IMPORT
2-EXPORT |
PERIOD | 202352-Jan.-Dec. 2023 |
INDICATOR | VALUE_EUR |
Finally, click "2.Layout Selection."
PART 3 -
Select the layouts as below. This is probably extremely confusing, so please refer to the picture.
All the "Format #X" should be "Labels."
ROWS => Dimension #1 | PARTNER |
ROWS => Dimension #2 | FLOW |
COLUMNS => Dimension #1 | PRODUCT |
PART 4
Click "Finish."
PART 5 -
You will probably get a really horrible picture that makes no sense,
.
To improve it, click "Chart" => "Vertical Bar Chart" => "Refresh". Then click "Spreadsheet,"
.
You now hopefully have a bad but usable picture that kind of makes sense, as shown in the attached picture.