How to go about stacked bar graph

[Akash01]

Year	PFCE	GFCE	GFCF	Export of goods and services	Import of goods and services
1950-51	9109	569	1169	736	711
1951-52	9994	597	1256	846	1038
1952-53	9971	618	1180	715	702
1953-54	10850	653	1166	644	652
1954-55	10098	681	1363	705	750
1955-56	10100	729	1646	757	839
1956-57	11913	804	2052	767	1174
1957-58	12084	940	2053	800	1304
1958-59	13718	1008	2058	719	1104
1959-60	14260	1062	2244	779	1010
1960-61	15409	1159	2549	787	1205
1961-62	16112	1288	2944	804	1113
1962-63	16969	1562	3206	837	1211
1963-64	18839	2007	3769	987	1362
1964-65	22179	2163	4380	1002	1529
1965-66	23411	2492	4855	938	1478
1966-67	27265	2731	5372	1330	2142
1967-68	32491	3054	6042	1517	2236
1968-69	32506	3344	6453	1608	1968
1969-70	35163	3748	7068	1628	1767
1970-71	37306	4189	7274	1771	1816
1971-72	40236	4848	8313	1838	2006
1972-73	44347	5157	9421	2225	2049
1973-74	53461	5653	10696	2830	3176
1974-75	64771	6859	13180	3835	4779
1975-76	66240	8085	15095	4812	5664
1976-77	68867	8979	16975	6139	5614
1977-78	79304	9580	19546	6640	6517

How do I plot a stacked bar graph with each stack containing all of the given columns(leaving the year of course ).
So basically against each year I need a stack of all of the given columns for that year.

[keithn]

You want to pivot your data into long format and then you'll be able to use this to create a column plot.

library(tidyr)
library(ggplot2)
data |>
  pivot_longer(cols = -"Year", names_to = "Category", values_to = "Count") |>
  ggplot(aes(x = Year, y = Count, fill = Category)) +
  geom_col()