Separating pie charts by dominate major category

[Adam Gallaher]

I am working with vehicle data attempting to produce a pie chart by body style and fuel type. My problem is my fossil fuel category dominates the pie chart hindering any ability to distinguish the other categories. So far I have

graph pie vehicles if datayear == 2013, over(fuel_type) plabel(_all percent) by(, title(`"Percent of Vehicles by Body Style and Fuel Type for 2013"')) by( body_style )

What I would like to do, if possible is have one pie chart for fossil fuels by body style and next to that the remaining fuel types by body style.

Below is example code.

* Example generated by -dataex-. For more info, type help dataex
clear
input int datayear str16 fuel_type str13 body_style double vehicles float fuel_type_dum
2013 "Alternative"      "Convertible"     347 0
2014 "Alternative"      "Convertible"     556 0
2015 "Alternative"      "Convertible"     823 0
2016 "Alternative"      "Convertible"    1086 0
2017 "Alternative"      "Convertible"    1237 0
2018 "Alternative"      "Convertible"    1263 0
2019 "Alternative"      "Convertible"    1238 0
2020 "Alternative"      "Convertible"    1227 0
2013 "Alternative"      "Coupe"           324 0
2014 "Alternative"      "Coupe"           487 0
2015 "Alternative"      "Coupe"           622 0
2016 "Alternative"      "Coupe"           804 0
2017 "Alternative"      "Coupe"           972 0
2018 "Alternative"      "Coupe"          1128 0
2019 "Alternative"      "Coupe"          1290 0
2020 "Alternative"      "Coupe"          1401 0
2013 "Alternative"      "Passenger Van" 13124 0
2014 "Alternative"      "Passenger Van" 14313 0
2015 "Alternative"      "Passenger Van" 15348 0
2016 "Alternative"      "Passenger Van" 16352 0
2017 "Alternative"      "Passenger Van" 17425 0
2018 "Alternative"      "Passenger Van" 17864 0
2019 "Alternative"      "Passenger Van" 18272 0
2020 "Alternative"      "Passenger Van" 18659 0
2013 "Alternative"      "Pickup Truck"  10741 0
2014 "Alternative"      "Pickup Truck"  12738 0
2015 "Alternative"      "Pickup Truck"  13883 0
2016 "Alternative"      "Pickup Truck"  14974 0
2017 "Alternative"      "Pickup Truck"  15935 0
2018 "Alternative"      "Pickup Truck"  16386 0
2019 "Alternative"      "Pickup Truck"  16613 0
2020 "Alternative"      "Pickup Truck"  16753 0
2013 "Alternative"      "SUV"           34979 0
2014 "Alternative"      "SUV"           42154 0
2015 "Alternative"      "SUV"           55112 0
2016 "Alternative"      "SUV"           69425 0
2017 "Alternative"      "SUV"           79936 0
2018 "Alternative"      "SUV"           87234 0
2019 "Alternative"      "SUV"           91713 0
2020 "Alternative"      "SUV"           95548 0
2013 "Alternative"      "Sedan"         17459 0
2014 "Alternative"      "Sedan"         19262 0
2015 "Alternative"      "Sedan"         21487 0
2016 "Alternative"      "Sedan"         23447 0
2017 "Alternative"      "Sedan"         23841 0
2018 "Alternative"      "Sedan"         23092 0
2019 "Alternative"      "Sedan"         22274 0
2020 "Alternative"      "Sedan"         21319 0
2013 "Alternative"      "Wagon"           440 0
2014 "Alternative"      "Wagon"           398 0
2015 "Alternative"      "Wagon"           363 0
2016 "Alternative"      "Wagon"           331 0
2017 "Alternative"      "Wagon"           301 0
2018 "Alternative"      "Wagon"           254 0
2019 "Alternative"      "Wagon"           234 0
2020 "Alternative"      "Wagon"           201 0
2013 "Battery Electric" "Convertible"      22 0
2014 "Battery Electric" "Convertible"      22 0
2015 "Battery Electric" "Convertible"      23 0
2016 "Battery Electric" "Convertible"      23 0
2017 "Battery Electric" "Convertible"      22 0
2018 "Battery Electric" "Convertible"      19 0
2019 "Battery Electric" "Convertible"      18 0
2020 "Battery Electric" "Convertible"      17 0
2013 "Battery Electric" "Coupe"            20 0
2014 "Battery Electric" "Coupe"            29 0
2015 "Battery Electric" "Coupe"            45 0
2016 "Battery Electric" "Coupe"            40 0
2017 "Battery Electric" "Coupe"            44 0
2018 "Battery Electric" "Coupe"            33 0
2019 "Battery Electric" "Coupe"            31 0
2020 "Battery Electric" "Coupe"            40 0
2013 "Battery Electric" "Hatchback"        70 0
2014 "Battery Electric" "Hatchback"       447 0
2015 "Battery Electric" "Hatchback"       761 0
2016 "Battery Electric" "Hatchback"      1213 0
2017 "Battery Electric" "Hatchback"      1554 0
2018 "Battery Electric" "Hatchback"      2307 0
2019 "Battery Electric" "Hatchback"      2835 0
2020 "Battery Electric" "Hatchback"      3164 0
2013 "Battery Electric" "Passenger Van"     1 0
2016 "Battery Electric" "Pickup Truck"      1 0
2017 "Battery Electric" "Pickup Truck"      1 0
2018 "Battery Electric" "Pickup Truck"      1 0
2020 "Battery Electric" "Pickup Truck"      1 0
2017 "Battery Electric" "SUV"             159 0
2018 "Battery Electric" "SUV"             349 0
2019 "Battery Electric" "SUV"             532 0
2020 "Battery Electric" "SUV"             884 0
2013 "Battery Electric" "Sedan"             1 0
2014 "Battery Electric" "Sedan"             1 0
2015 "Battery Electric" "Sedan"             1 0
2016 "Battery Electric" "Sedan"             2 0
2017 "Battery Electric" "Sedan"             3 0
2018 "Battery Electric" "Sedan"             3 0
2019 "Battery Electric" "Sedan"          1035 0
2020 "Battery Electric" "Sedan"          2347 0
2013 "Fossil Fuels"     "Convertible"   69565 1
2014 "Fossil Fuels"     "Convertible"   68027 1
2015 "Fossil Fuels"     "Convertible"   66982 1
end

Thank you for your time.
Adam

[Nick Cox]

Your sample data don't show the problem. Perhaps show a reduced dataset from say

collapse (sum) vehicles, by(datayear body_style fuel_type)

[Adam Gallaher]

My apologies Nick, what I provided is a collapsed form of the original data. This should highlight the problem now, I've expanded the count beyond 100.

* Example generated by -dataex-. For more info, type help dataex
clear
input int datayear str16 fuel_type str13 body_style double vehicles float fuel_type_dum
2013 "Alternative"      "Convertible"       347 0
2014 "Alternative"      "Convertible"       556 0
2015 "Alternative"      "Convertible"       823 0
2016 "Alternative"      "Convertible"      1086 0
2017 "Alternative"      "Convertible"      1237 0
2018 "Alternative"      "Convertible"      1263 0
2019 "Alternative"      "Convertible"      1238 0
2020 "Alternative"      "Convertible"      1227 0
2013 "Alternative"      "Coupe"             324 0
2014 "Alternative"      "Coupe"             487 0
2015 "Alternative"      "Coupe"             622 0
2016 "Alternative"      "Coupe"             804 0
2017 "Alternative"      "Coupe"             972 0
2018 "Alternative"      "Coupe"            1128 0
2019 "Alternative"      "Coupe"            1290 0
2020 "Alternative"      "Coupe"            1401 0
2013 "Alternative"      "Passenger Van"   13124 0
2014 "Alternative"      "Passenger Van"   14313 0
2015 "Alternative"      "Passenger Van"   15348 0
2016 "Alternative"      "Passenger Van"   16352 0
2017 "Alternative"      "Passenger Van"   17425 0
2018 "Alternative"      "Passenger Van"   17864 0
2019 "Alternative"      "Passenger Van"   18272 0
2020 "Alternative"      "Passenger Van"   18659 0
2013 "Alternative"      "Pickup Truck"    10741 0
2014 "Alternative"      "Pickup Truck"    12738 0
2015 "Alternative"      "Pickup Truck"    13883 0
2016 "Alternative"      "Pickup Truck"    14974 0
2017 "Alternative"      "Pickup Truck"    15935 0
2018 "Alternative"      "Pickup Truck"    16386 0
2019 "Alternative"      "Pickup Truck"    16613 0
2020 "Alternative"      "Pickup Truck"    16753 0
2013 "Alternative"      "SUV"             34979 0
2014 "Alternative"      "SUV"             42154 0
2015 "Alternative"      "SUV"             55112 0
2016 "Alternative"      "SUV"             69425 0
2017 "Alternative"      "SUV"             79936 0
2018 "Alternative"      "SUV"             87234 0
2019 "Alternative"      "SUV"             91713 0
2020 "Alternative"      "SUV"             95548 0
2013 "Alternative"      "Sedan"           17459 0
2014 "Alternative"      "Sedan"           19262 0
2015 "Alternative"      "Sedan"           21487 0
2016 "Alternative"      "Sedan"           23447 0
2017 "Alternative"      "Sedan"           23841 0
2018 "Alternative"      "Sedan"           23092 0
2019 "Alternative"      "Sedan"           22274 0
2020 "Alternative"      "Sedan"           21319 0
2013 "Alternative"      "Wagon"             440 0
2014 "Alternative"      "Wagon"             398 0
2015 "Alternative"      "Wagon"             363 0
2016 "Alternative"      "Wagon"             331 0
2017 "Alternative"      "Wagon"             301 0
2018 "Alternative"      "Wagon"             254 0
2019 "Alternative"      "Wagon"             234 0
2020 "Alternative"      "Wagon"             201 0
2013 "Battery Electric" "Convertible"        22 0
2014 "Battery Electric" "Convertible"        22 0
2015 "Battery Electric" "Convertible"        23 0
2016 "Battery Electric" "Convertible"        23 0
2017 "Battery Electric" "Convertible"        22 0
2018 "Battery Electric" "Convertible"        19 0
2019 "Battery Electric" "Convertible"        18 0
2020 "Battery Electric" "Convertible"        17 0
2013 "Battery Electric" "Coupe"              20 0
2014 "Battery Electric" "Coupe"              29 0
2015 "Battery Electric" "Coupe"              45 0
2016 "Battery Electric" "Coupe"              40 0
2017 "Battery Electric" "Coupe"              44 0
2018 "Battery Electric" "Coupe"              33 0
2019 "Battery Electric" "Coupe"              31 0
2020 "Battery Electric" "Coupe"              40 0
2013 "Battery Electric" "Hatchback"          70 0
2014 "Battery Electric" "Hatchback"         447 0
2015 "Battery Electric" "Hatchback"         761 0
2016 "Battery Electric" "Hatchback"        1213 0
2017 "Battery Electric" "Hatchback"        1554 0
2018 "Battery Electric" "Hatchback"        2307 0
2019 "Battery Electric" "Hatchback"        2835 0
2020 "Battery Electric" "Hatchback"        3164 0
2013 "Battery Electric" "Passenger Van"       1 0
2016 "Battery Electric" "Pickup Truck"        1 0
2017 "Battery Electric" "Pickup Truck"        1 0
2018 "Battery Electric" "Pickup Truck"        1 0
2020 "Battery Electric" "Pickup Truck"        1 0
2017 "Battery Electric" "SUV"               159 0
2018 "Battery Electric" "SUV"               349 0
2019 "Battery Electric" "SUV"               532 0
2020 "Battery Electric" "SUV"               884 0
2013 "Battery Electric" "Sedan"               1 0
2014 "Battery Electric" "Sedan"               1 0
2015 "Battery Electric" "Sedan"               1 0
2016 "Battery Electric" "Sedan"               2 0
2017 "Battery Electric" "Sedan"               3 0
2018 "Battery Electric" "Sedan"               3 0
2019 "Battery Electric" "Sedan"            1035 0
2020 "Battery Electric" "Sedan"            2347 0
2013 "Fossil Fuels"     "Convertible"     69565 1
2014 "Fossil Fuels"     "Convertible"     68027 1
2015 "Fossil Fuels"     "Convertible"     66982 1
2016 "Fossil Fuels"     "Convertible"     66226 1
2017 "Fossil Fuels"     "Convertible"     66360 1
2018 "Fossil Fuels"     "Convertible"     65805 1
2019 "Fossil Fuels"     "Convertible"     64683 1
2020 "Fossil Fuels"     "Convertible"     63335 1
2013 "Fossil Fuels"     "Coupe"          136951 1
2014 "Fossil Fuels"     "Coupe"          130620 1
2015 "Fossil Fuels"     "Coupe"          126737 1
2016 "Fossil Fuels"     "Coupe"          122579 1
2017 "Fossil Fuels"     "Coupe"          119675 1
2018 "Fossil Fuels"     "Coupe"          114861 1
2019 "Fossil Fuels"     "Coupe"          109213 1
2020 "Fossil Fuels"     "Coupe"          103652 1
2013 "Fossil Fuels"     "Hatchback"      106685 1
2014 "Fossil Fuels"     "Hatchback"      104726 1
2015 "Fossil Fuels"     "Hatchback"      105010 1
2016 "Fossil Fuels"     "Hatchback"      105048 1
2017 "Fossil Fuels"     "Hatchback"      104930 1
2018 "Fossil Fuels"     "Hatchback"      102955 1
2019 "Fossil Fuels"     "Hatchback"      101663 1
2020 "Fossil Fuels"     "Hatchback"       99730 1
2013 "Fossil Fuels"     "Passenger Van"  145039 1
2014 "Fossil Fuels"     "Passenger Van"  133114 1
2015 "Fossil Fuels"     "Passenger Van"  125273 1
2016 "Fossil Fuels"     "Passenger Van"  118366 1
2017 "Fossil Fuels"     "Passenger Van"  113520 1
2018 "Fossil Fuels"     "Passenger Van"  106796 1
2019 "Fossil Fuels"     "Passenger Van"  100721 1
2020 "Fossil Fuels"     "Passenger Van"   94678 1
2013 "Fossil Fuels"     "Pickup Truck"   161133 1
2014 "Fossil Fuels"     "Pickup Truck"   155378 1
2015 "Fossil Fuels"     "Pickup Truck"   155350 1
2016 "Fossil Fuels"     "Pickup Truck"   157729 1
2017 "Fossil Fuels"     "Pickup Truck"   163200 1
2018 "Fossil Fuels"     "Pickup Truck"   166530 1
2019 "Fossil Fuels"     "Pickup Truck"   171175 1
2020 "Fossil Fuels"     "Pickup Truck"   177647 1
2013 "Fossil Fuels"     "SUV"            687977 1
2014 "Fossil Fuels"     "SUV"            701595 1
2015 "Fossil Fuels"     "SUV"            749140 1
2016 "Fossil Fuels"     "SUV"            803274 1
2017 "Fossil Fuels"     "SUV"            859621 1
2018 "Fossil Fuels"     "SUV"            904421 1
2019 "Fossil Fuels"     "SUV"            960791 1
2020 "Fossil Fuels"     "SUV"           1014080 1
2013 "Fossil Fuels"     "Sedan"         1095256 1
2014 "Fossil Fuels"     "Sedan"         1066140 1
2015 "Fossil Fuels"     "Sedan"         1072856 1
2016 "Fossil Fuels"     "Sedan"         1072824 1
2017 "Fossil Fuels"     "Sedan"         1070837 1
2018 "Fossil Fuels"     "Sedan"         1040440 1
2019 "Fossil Fuels"     "Sedan"         1008638 1
2020 "Fossil Fuels"     "Sedan"          974609 1
2013 "Fossil Fuels"     "Wagon"           98190 1
2014 "Fossil Fuels"     "Wagon"           92756 1
2015 "Fossil Fuels"     "Wagon"           89218 1
2016 "Fossil Fuels"     "Wagon"           86328 1
2017 "Fossil Fuels"     "Wagon"           83846 1
2018 "Fossil Fuels"     "Wagon"           80802 1
2019 "Fossil Fuels"     "Wagon"           79200 1
2020 "Fossil Fuels"     "Wagon"           78123 1
2019 "Hybrid"           "Convertible"         6 0
2020 "Hybrid"           "Convertible"        16 0
2015 "Hybrid"           "Coupe"               1 0
2016 "Hybrid"           "Coupe"               2 0
2017 "Hybrid"           "Coupe"               8 0
2018 "Hybrid"           "Coupe"              10 0
2019 "Hybrid"           "Coupe"              17 0
2020 "Hybrid"           "Coupe"              32 0
2013 "Hybrid"           "Hatchback"       17057 0
2014 "Hybrid"           "Hatchback"       18376 0
2015 "Hybrid"           "Hatchback"       20092 0
2016 "Hybrid"           "Hatchback"       20743 0
2017 "Hybrid"           "Hatchback"       21075 0
2018 "Hybrid"           "Hatchback"       20617 0
2019 "Hybrid"           "Hatchback"       20663 0
2020 "Hybrid"           "Hatchback"       20873 0
2013 "Hybrid"           "Pickup Truck"       21 0
2014 "Hybrid"           "Pickup Truck"       26 0
2015 "Hybrid"           "Pickup Truck"       24 0
2016 "Hybrid"           "Pickup Truck"       21 0
2017 "Hybrid"           "Pickup Truck"       23 0
2018 "Hybrid"           "Pickup Truck"       29 0
2019 "Hybrid"           "Pickup Truck"      156 0
2020 "Hybrid"           "Pickup Truck"      386 0
2013 "Hybrid"           "SUV"              5541 0
2014 "Hybrid"           "SUV"              5688 0
2015 "Hybrid"           "SUV"              6123 0
2016 "Hybrid"           "SUV"              6310 0
2017 "Hybrid"           "SUV"              7113 0
2018 "Hybrid"           "SUV"              8250 0
2019 "Hybrid"           "SUV"              9918 0
2020 "Hybrid"           "SUV"             14063 0
2013 "Hybrid"           "Sedan"            9433 0
2014 "Hybrid"           "Sedan"           11158 0
2015 "Hybrid"           "Sedan"           13165 0
2016 "Hybrid"           "Sedan"           14217 0
2017 "Hybrid"           "Sedan"           14698 0
2018 "Hybrid"           "Sedan"           14734 0
2019 "Hybrid"           "Sedan"           15263 0
2020 "Hybrid"           "Sedan"           16635 0
2013 "Hybrid"           "Wagon"             466 0
2014 "Hybrid"           "Wagon"             747 0
2015 "Hybrid"           "Wagon"            1019 0
2016 "Hybrid"           "Wagon"            1174 0
2017 "Hybrid"           "Wagon"            1266 0
2018 "Hybrid"           "Wagon"            1304 0
2019 "Hybrid"           "Wagon"            1282 0
2020 "Hybrid"           "Wagon"            1396 0
2019 "Plug-in Hybrid"   "Convertible"         4 0
2020 "Plug-in Hybrid"   "Convertible"        12 0
2015 "Plug-in Hybrid"   "Coupe"              25 0
2016 "Plug-in Hybrid"   "Coupe"              59 0
2017 "Plug-in Hybrid"   "Coupe"              73 0
2018 "Plug-in Hybrid"   "Coupe"              76 0
2019 "Plug-in Hybrid"   "Coupe"              78 0
2020 "Plug-in Hybrid"   "Coupe"              73 0
2013 "Plug-in Hybrid"   "Hatchback"         474 0
2014 "Plug-in Hybrid"   "Hatchback"         956 0
2015 "Plug-in Hybrid"   "Hatchback"        1476 0
2016 "Plug-in Hybrid"   "Hatchback"        1864 0
2017 "Plug-in Hybrid"   "Hatchback"        2203 0
2018 "Plug-in Hybrid"   "Hatchback"        2906 0
2019 "Plug-in Hybrid"   "Hatchback"        3510 0
2020 "Plug-in Hybrid"   "Hatchback"        3695 0
2018 "Plug-in Hybrid"   "Passenger Van"      31 0
2019 "Plug-in Hybrid"   "Passenger Van"      89 0
2020 "Plug-in Hybrid"   "Passenger Van"     124 0
2015 "Plug-in Hybrid"   "SUV"                 1 0
2016 "Plug-in Hybrid"   "SUV"                23 0
2017 "Plug-in Hybrid"   "SUV"               173 0
2018 "Plug-in Hybrid"   "SUV"               347 0
2019 "Plug-in Hybrid"   "SUV"               508 0
2020 "Plug-in Hybrid"   "SUV"               720 0
2013 "Plug-in Hybrid"   "Sedan"              15 0
2014 "Plug-in Hybrid"   "Sedan"              62 0
2015 "Plug-in Hybrid"   "Sedan"             151 0
2016 "Plug-in Hybrid"   "Sedan"             252 0
2017 "Plug-in Hybrid"   "Sedan"             438 0
2018 "Plug-in Hybrid"   "Sedan"             596 0
2019 "Plug-in Hybrid"   "Sedan"            1132 0
2020 "Plug-in Hybrid"   "Sedan"            1285 0
2018 "Plug-in Hybrid"   "Wagon"               8 0
2019 "Plug-in Hybrid"   "Wagon"              25 0
2020 "Plug-in Hybrid"   "Wagon"              37 0
end

[Nick Cox]

Thanks for expanding the example data.

As you say, you have many small percents to show -- so much so that I think pie charts are dooomed as ineffective. I used tabplot and myaxis from the Stata Journal to get a token graph for fuels other than fossil.

bysort datayear body_style : egen total = total(vehicles)
gen toshow = 100 * vehicles / total

myaxis col=fuel_type , sort(mean toshow) descending 
myaxis row=body_style, sort(mean toshow) descending 

quantile toshow , name(qplot, replace)

tabplot row col  if fuel_type != "Fossil Fuels"  & datayear == 2020  [iw=toshow], showval(format(%3.2f) offset(0.2)) horizontal xtitle("") ytitle("") subtitle(2020) xsc(r(0.8 4.8))  separate(fuel_type)

[Nick Cox]

One option -- no choices are completely satisfactory here -- is to suppress the bars for fossil fuels but show the percents any way.

bysort datayear body_style : egen total = total(vehicles)
gen toshow = 100 * vehicles / total

myaxis col=fuel_type , sort(mean toshow) descending 
myaxis row=body_style, sort(mean toshow) descending 

gen TOSHOW = strofreal(toshow, "%3.2f")
replace toshow = 1e-6 if fuel_type == "Fossil Fuels"

tabplot row col  if datayear == 2020  [iw=toshow], showval(TOSHOW, offset(0.2)) horizontal xtitle("") ytitle("") subtitle(2020) xsc(r(0.6 5.8))  separate(fuel_type)

[Adam Gallaher]

Thank you for the suggestion, Nick. This worked out quite well and I would agree, a better option compared to pie charts.

[Adam Gallaher]

Hello, I am back with a similar question using the same data. I am looking to create a Sankey diagram by year (datayear) showing the flow between body style and fuel type over time. However, for visualization purposes it might make more sense to stick with change between 2013 and 2020. Below is an example of the dataset along with basic code to generate a Sankey diagram. Any suggestions or help would be appreciated.

Thank you,

Adam

sankey vehicles, from(body_style) to(fuel_type) by(datayear)

 
 * Example generated by -dataex-. For more info, type help dataex clear input int datayear str16 fuel_type str13 body_style double vehicles float fuel_type_dum 2013 "Alternative"      "Convertible"       347 0 2014 "Alternative"      "Convertible"       556 0 2015 "Alternative"      "Convertible"       823 0 2016 "Alternative"      "Convertible"      1086 0 2017 "Alternative"      "Convertible"      1237 0 2018 "Alternative"      "Convertible"      1263 0 2019 "Alternative"      "Convertible"      1238 0 2020 "Alternative"      "Convertible"      1227 0 2013 "Alternative"      "Coupe"             324 0 2014 "Alternative"      "Coupe"             487 0 2015 "Alternative"      "Coupe"             622 0 2016 "Alternative"      "Coupe"             804 0 2017 "Alternative"      "Coupe"             972 0 2018 "Alternative"      "Coupe"            1128 0 2019 "Alternative"      "Coupe"            1290 0 2020 "Alternative"      "Coupe"            1401 0 2013 "Alternative"      "Passenger Van"   13124 0 2014 "Alternative"      "Passenger Van"   14313 0 2015 "Alternative"      "Passenger Van"   15348 0 2016 "Alternative"      "Passenger Van"   16352 0 2017 "Alternative"      "Passenger Van"   17425 0 2018 "Alternative"      "Passenger Van"   17864 0 2019 "Alternative"      "Passenger Van"   18272 0 2020 "Alternative"      "Passenger Van"   18659 0 2013 "Alternative"      "Pickup Truck"    10741 0 2014 "Alternative"      "Pickup Truck"    12738 0 2015 "Alternative"      "Pickup Truck"    13883 0 2016 "Alternative"      "Pickup Truck"    14974 0 2017 "Alternative"      "Pickup Truck"    15935 0 2018 "Alternative"      "Pickup Truck"    16386 0 2019 "Alternative"      "Pickup Truck"    16613 0 2020 "Alternative"      "Pickup Truck"    16753 0 2013 "Alternative"      "SUV"             34979 0 2014 "Alternative"      "SUV"             42154 0 2015 "Alternative"      "SUV"             55112 0 2016 "Alternative"      "SUV"             69425 0 2017 "Alternative"      "SUV"             79936 0 2018 "Alternative"      "SUV"             87234 0 2019 "Alternative"      "SUV"             91713 0 2020 "Alternative"      "SUV"             95548 0 2013 "Alternative"      "Sedan"           17459 0 2014 "Alternative"      "Sedan"           19262 0 2015 "Alternative"      "Sedan"           21487 0 2016 "Alternative"      "Sedan"           23447 0 2017 "Alternative"      "Sedan"           23841 0 2018 "Alternative"      "Sedan"           23092 0 2019 "Alternative"      "Sedan"           22274 0 2020 "Alternative"      "Sedan"           21319 0 2013 "Alternative"      "Wagon"             440 0 2014 "Alternative"      "Wagon"             398 0 2015 "Alternative"      "Wagon"             363 0 2016 "Alternative"      "Wagon"             331 0 2017 "Alternative"      "Wagon"             301 0 2018 "Alternative"      "Wagon"             254 0 2019 "Alternative"      "Wagon"             234 0 2020 "Alternative"      "Wagon"             201 0 2013 "Battery Electric" "Convertible"        22 0 2014 "Battery Electric" "Convertible"        22 0 2015 "Battery Electric" "Convertible"        23 0 2016 "Battery Electric" "Convertible"        23 0 2017 "Battery Electric" "Convertible"        22 0 2018 "Battery Electric" "Convertible"        19 0 2019 "Battery Electric" "Convertible"        18 0 2020 "Battery Electric" "Convertible"        17 0 2013 "Battery Electric" "Coupe"              20 0 2014 "Battery Electric" "Coupe"              29 0 2015 "Battery Electric" "Coupe"              45 0 2016 "Battery Electric" "Coupe"              40 0 2017 "Battery Electric" "Coupe"              44 0 2018 "Battery Electric" "Coupe"              33 0 2019 "Battery Electric" "Coupe"              31 0 2020 "Battery Electric" "Coupe"              40 0 2013 "Battery Electric" "Hatchback"          70 0 2014 "Battery Electric" "Hatchback"         447 0 2015 "Battery Electric" "Hatchback"         761 0 2016 "Battery Electric" "Hatchback"        1213 0 2017 "Battery Electric" "Hatchback"        1554 0 2018 "Battery Electric" "Hatchback"        2307 0 2019 "Battery Electric" "Hatchback"        2835 0 2020 "Battery Electric" "Hatchback"        3164 0 2013 "Battery Electric" "Passenger Van"       1 0 2016 "Battery Electric" "Pickup Truck"        1 0 2017 "Battery Electric" "Pickup Truck"        1 0 2018 "Battery Electric" "Pickup Truck"        1 0 2020 "Battery Electric" "Pickup Truck"        1 0 2017 "Battery Electric" "SUV"               159 0 2018 "Battery Electric" "SUV"               349 0 2019 "Battery Electric" "SUV"               532 0 2020 "Battery Electric" "SUV"               884 0 2013 "Battery Electric" "Sedan"               1 0 2014 "Battery Electric" "Sedan"               1 0 2015 "Battery Electric" "Sedan"               1 0 2016 "Battery Electric" "Sedan"               2 0 2017 "Battery Electric" "Sedan"               3 0 2018 "Battery Electric" "Sedan"               3 0 2019 "Battery Electric" "Sedan"            1035 0 2020 "Battery Electric" "Sedan"            2347 0 2013 "Fossil Fuels"     "Convertible"     69565 1 2014 "Fossil Fuels"     "Convertible"     68027 1 2015 "Fossil Fuels"     "Convertible"     66982 1 2016 "Fossil Fuels"     "Convertible"     66226 1 2017 "Fossil Fuels"     "Convertible"     66360 1 2018 "Fossil Fuels"     "Convertible"     65805 1 2019 "Fossil Fuels"     "Convertible"     64683 1 2020 "Fossil Fuels"     "Convertible"     63335 1 2013 "Fossil Fuels"     "Coupe"          136951 1 2014 "Fossil Fuels"     "Coupe"          130620 1 2015 "Fossil Fuels"     "Coupe"          126737 1 2016 "Fossil Fuels"     "Coupe"          122579 1 2017 "Fossil Fuels"     "Coupe"          119675 1 2018 "Fossil Fuels"     "Coupe"          114861 1 2019 "Fossil Fuels"     "Coupe"          109213 1 2020 "Fossil Fuels"     "Coupe"          103652 1 2013 "Fossil Fuels"     "Hatchback"      106685 1 2014 "Fossil Fuels"     "Hatchback"      104726 1 2015 "Fossil Fuels"     "Hatchback"      105010 1 2016 "Fossil Fuels"     "Hatchback"      105048 1 2017 "Fossil Fuels"     "Hatchback"      104930 1 2018 "Fossil Fuels"     "Hatchback"      102955 1 2019 "Fossil Fuels"     "Hatchback"      101663 1 2020 "Fossil Fuels"     "Hatchback"       99730 1 2013 "Fossil Fuels"     "Passenger Van"  145039 1 2014 "Fossil Fuels"     "Passenger Van"  133114 1 2015 "Fossil Fuels"     "Passenger Van"  125273 1 2016 "Fossil Fuels"     "Passenger Van"  118366 1 2017 "Fossil Fuels"     "Passenger Van"  113520 1 2018 "Fossil Fuels"     "Passenger Van"  106796 1 2019 "Fossil Fuels"     "Passenger Van"  100721 1 2020 "Fossil Fuels"     "Passenger Van"   94678 1 2013 "Fossil Fuels"     "Pickup Truck"   161133 1 2014 "Fossil Fuels"     "Pickup Truck"   155378 1 2015 "Fossil Fuels"     "Pickup Truck"   155350 1 2016 "Fossil Fuels"     "Pickup Truck"   157729 1 2017 "Fossil Fuels"     "Pickup Truck"   163200 1 2018 "Fossil Fuels"     "Pickup Truck"   166530 1 2019 "Fossil Fuels"     "Pickup Truck"   171175 1 2020 "Fossil Fuels"     "Pickup Truck"   177647 1 2013 "Fossil Fuels"     "SUV"            687977 1 2014 "Fossil Fuels"     "SUV"            701595 1 2015 "Fossil Fuels"     "SUV"            749140 1 2016 "Fossil Fuels"     "SUV"            803274 1 2017 "Fossil Fuels"     "SUV"            859621 1 2018 "Fossil Fuels"     "SUV"            904421 1 2019 "Fossil Fuels"     "SUV"            960791 1 2020 "Fossil Fuels"     "SUV"           1014080 1 2013 "Fossil Fuels"     "Sedan"         1095256 1 2014 "Fossil Fuels"     "Sedan"         1066140 1 2015 "Fossil Fuels"     "Sedan"         1072856 1 2016 "Fossil Fuels"     "Sedan"         1072824 1 2017 "Fossil Fuels"     "Sedan"         1070837 1 2018 "Fossil Fuels"     "Sedan"         1040440 1 2019 "Fossil Fuels"     "Sedan"         1008638 1 2020 "Fossil Fuels"     "Sedan"          974609 1 2013 "Fossil Fuels"     "Wagon"           98190 1 2014 "Fossil Fuels"     "Wagon"           92756 1 2015 "Fossil Fuels"     "Wagon"           89218 1 2016 "Fossil Fuels"     "Wagon"           86328 1 2017 "Fossil Fuels"     "Wagon"           83846 1 2018 "Fossil Fuels"     "Wagon"           80802 1 2019 "Fossil Fuels"     "Wagon"           79200 1 2020 "Fossil Fuels"     "Wagon"           78123 1 2019 "Hybrid"           "Convertible"         6 0 2020 "Hybrid"           "Convertible"        16 0 2015 "Hybrid"           "Coupe"               1 0 2016 "Hybrid"           "Coupe"               2 0 2017 "Hybrid"           "Coupe"               8 0 2018 "Hybrid"           "Coupe"              10 0 2019 "Hybrid"           "Coupe"              17 0 2020 "Hybrid"           "Coupe"              32 0 2013 "Hybrid"           "Hatchback"       17057 0 2014 "Hybrid"           "Hatchback"       18376 0 2015 "Hybrid"           "Hatchback"       20092 0 2016 "Hybrid"           "Hatchback"       20743 0 2017 "Hybrid"           "Hatchback"       21075 0 2018 "Hybrid"           "Hatchback"       20617 0 2019 "Hybrid"           "Hatchback"       20663 0 2020 "Hybrid"           "Hatchback"       20873 0 2013 "Hybrid"           "Pickup Truck"       21 0 2014 "Hybrid"           "Pickup Truck"       26 0 2015 "Hybrid"           "Pickup Truck"       24 0 2016 "Hybrid"           "Pickup Truck"       21 0 2017 "Hybrid"           "Pickup Truck"       23 0 2018 "Hybrid"           "Pickup Truck"       29 0 2019 "Hybrid"           "Pickup Truck"      156 0 2020 "Hybrid"           "Pickup Truck"      386 0 2013 "Hybrid"           "SUV"              5541 0 2014 "Hybrid"           "SUV"              5688 0 2015 "Hybrid"           "SUV"              6123 0 2016 "Hybrid"           "SUV"              6310 0 2017 "Hybrid"           "SUV"              7113 0 2018 "Hybrid"           "SUV"              8250 0 2019 "Hybrid"           "SUV"              9918 0 2020 "Hybrid"           "SUV"             14063 0 2013 "Hybrid"           "Sedan"            9433 0 2014 "Hybrid"           "Sedan"           11158 0 2015 "Hybrid"           "Sedan"           13165 0 2016 "Hybrid"           "Sedan"           14217 0 2017 "Hybrid"           "Sedan"           14698 0 2018 "Hybrid"           "Sedan"           14734 0 2019 "Hybrid"           "Sedan"           15263 0 2020 "Hybrid"           "Sedan"           16635 0 2013 "Hybrid"           "Wagon"             466 0 2014 "Hybrid"           "Wagon"             747 0 2015 "Hybrid"           "Wagon"            1019 0 2016 "Hybrid"           "Wagon"            1174 0 2017 "Hybrid"           "Wagon"            1266 0 2018 "Hybrid"           "Wagon"            1304 0 2019 "Hybrid"           "Wagon"            1282 0 2020 "Hybrid"           "Wagon"            1396 0 2019 "Plug-in Hybrid"   "Convertible"         4 0 2020 "Plug-in Hybrid"   "Convertible"        12 0 2015 "Plug-in Hybrid"   "Coupe"              25 0 2016 "Plug-in Hybrid"   "Coupe"              59 0 2017 "Plug-in Hybrid"   "Coupe"              73 0 2018 "Plug-in Hybrid"   "Coupe"              76 0 2019 "Plug-in Hybrid"   "Coupe"              78 0 2020 "Plug-in Hybrid"   "Coupe"              73 0 2013 "Plug-in Hybrid"   "Hatchback"         474 0 2014 "Plug-in Hybrid"   "Hatchback"         956 0 2015 "Plug-in Hybrid"   "Hatchback"        1476 0 2016 "Plug-in Hybrid"   "Hatchback"        1864 0 2017 "Plug-in Hybrid"   "Hatchback"        2203 0 2018 "Plug-in Hybrid"   "Hatchback"        2906 0 2019 "Plug-in Hybrid"   "Hatchback"        3510 0 2020 "Plug-in Hybrid"   "Hatchback"        3695 0 2018 "Plug-in Hybrid"   "Passenger Van"      31 0 2019 "Plug-in Hybrid"   "Passenger Van"      89 0 2020 "Plug-in Hybrid"   "Passenger Van"     124 0 2015 "Plug-in Hybrid"   "SUV"                 1 0 2016 "Plug-in Hybrid"   "SUV"                23 0 2017 "Plug-in Hybrid"   "SUV"               173 0 2018 "Plug-in Hybrid"   "SUV"               347 0 2019 "Plug-in Hybrid"   "SUV"               508 0 2020 "Plug-in Hybrid"   "SUV"               720 0 2013 "Plug-in Hybrid"   "Sedan"              15 0 2014 "Plug-in Hybrid"   "Sedan"              62 0 2015 "Plug-in Hybrid"   "Sedan"             151 0 2016 "Plug-in Hybrid"   "Sedan"             252 0 2017 "Plug-in Hybrid"   "Sedan"             438 0 2018 "Plug-in Hybrid"   "Sedan"             596 0 2019 "Plug-in Hybrid"   "Sedan"            1132 0 2020 "Plug-in Hybrid"   "Sedan"            1285 0 2018 "Plug-in Hybrid"   "Wagon"               8 0 2019 "Plug-in Hybrid"   "Wagon"              25 0 2020 "Plug-in Hybrid"   "Wagon"              37 0 end

[Nick Cox]

I recommend starting a new thread with the keyword Sankey in the title. You might also explain the provenance of the command you are using and ping the program author. Sankey charts might be of interest to many readers not excited about pie charts.

[Adam Gallaher]

Perfect, thank you Nick for the recommendation. I agree, both visualizations have their own audience preference.