M Chart Pro

Display as Table

Flip the Display as Table switch and a chart’s data publishes as an interactive table instead. Readers can sort, search, and page through it, and filter from a menu on each column. Your chart settings are kept, so switching back is one click.

See it live

This is an ordinary M Chart chart with Display as Table switched on. Sort by any column, search, open a column menu to filter, and page through all 135 countries. Numbers keep the chart’s formatting but sort by value.

Cucumber & gherkin production by country, 2017–2022: Tonnes per year, FAOSTAT
RankCountry202220212020201920182017Change 2017–2022
1China77,258,25674,815,09372,927,96970,388,97167,601,86365,156,96318.6%
2Turkey1,938,5451,890,1601,886,2391,916,6451,890,9041,827,7826.1%
3Russia1,635,9031,602,6061,686,9761,626,4121,604,3461,504,9658.7%
4Mexico1,078,2101,038,9991,159,9341,191,6081,072,048956,00512.8%
5Uzbekistan904,390890,433812,728855,058857,076813,59111.2%
6Ukraine825,5901,079,9601,012,5301,034,170985,120896,280-7.9%
7Spain769,970745,910794,880739,200643,660634,82421.3%
8United States595,630642,967567,245670,251700,820857,870-30.6%
9Kazakhstan568,748582,135537,775494,672460,110409,70038.8%
10Japan548,600551,300539,300548,10055,000559,500-1.9%
11Egypt484,425491,650443,500566,155366,661393,43223.1%
12Poland472,200473,000526,500519,400538,680543,726-13.2%
13Indonesia444,057471,941441,286435,973433,923424,9334.5%
14Iran411,3611,483,092571,441667,359650,882751,160-45.2%
15Netherlands400,130440,440430,170410,250410,410400,0000%
16South Korea275,203283,933335,596366,065391,214341,364-19.4%
17Cameroon262,121262,440258,988264,934263,398248,6325.4%
18Tajikistan257,203283,344262,556235,747211,612178,03544.5%
19Azerbaijan246,572245,847226,929248,891223,790220,90311.6%
20Germany233,710242,800216,970249,920267,590256,689-9%
21Belarus228,448212,788216,982230,793226,443236,618-3.5%
22Sudan227,043226,749224,103230,277225,866216,1665%
23Saudi Arabia204,720188,558184,86066,360115,617111,43183.7%
24Iraq195,924185,484242,614149,302138,35396,664102.7%
25Algeria190,925182,890184,362166,045193,647171,61011.3%
26India183,223182,325184,565182,780179,629177,1493.4%
27Thailand177,068176,479177,052177,672174,712178,773-1%
28France175,180200,150213,540139,140137,850145,98120%
29Bangladesh173,998156,744130,259119,136112,974121,25443.5%
30Jordan173,682131,301141,383163,484208,226190,847-9%
31Greece142,490155,800158,510149,740155,480142,2890.1%
32Albania129,896118,171113,685126,632120,351110,21017.9%
33Kyrgyzstan126,811129,159129,122130,007119,569118,2827.2%
34Syria125,495151,844182,415136,567175,758185,208-32.2%
35Lebanon123,685121,005120,090128,710124,480110,14712.3%
36United Arab Emirates120,743114,274105,76591,90371,35053,915124%
37Pakistan112,23147,41746,01477,57368,66465,59771.1%
38Palestine112,014117,938107,120110,050113,870103,1338.6%
39Mali105,87683,95798,75172,94479,03168,88253.7%
40Malaysia102,36996,353101,482103,36385,13488,49215.7%
41Oman97,13993,114102,68273,98373,26762,97754.2%
42Israel80,49295,03891,89294,604101,846103,425-22.2%
43Kuwait79,94873,14348,88096,39158,59170,43613.5%
44Cuba79,18580,23281,71295,700106,708148,497-46.7%
45Romania77,830149,990165,070118,630138,610201,001-61.3%
46Tunisia70,11170,08570,26669,98270,00870,808-1%
47North Korea67,19367,11067,02867,05266,96966,9530.4%
48Morocco63,15559,85146,41657,44847,78748,73529.6%
49Italy61,83062,95060,69060,60054,09054,44413.6%
50Canada60,72157,72057,65565,41657,29562,204-2.4%
51Finland56,96060,03059,91056,13055,33050,76312.2%
52Armenia56,53658,71343,23144,14150,59974,336-23.9%
53Bulgaria52,27053,68053,63072,97074,35054,398-3.9%
54Peru50,55955,01252,10645,44844,28847,6686.1%
55Australia48,26458,20741,23437,05231,83829,80861.9%
56North Macedonia48,19052,95049,11251,01954,31451,532-6.5%
57Taiwan47,08347,97551,33148,96851,22451,264-8.2%
58United Kingdom45,00054,99258,41058,24055,08052,968-15%
59Honduras44,31445,00047,00040,00038,42835,82723.7%
60Austria44,11047,74046,33045,27044,85046,581-5.3%
61Chile37,42937,35337,17437,75937,12636,6372.2%
62Sri Lanka37,14239,09742,22939,04449,76733,12812.1%
63Sweden36,92043,53038,52037,90035,79038,100-3.1%
64Colombia36,79034,11428,42440,98238,74233,6649.3%
65Belgium34,92032,04027,60027,47024,49025,53036.8%
66Turkmenistan34,24334,27534,33234,12034,37234,504-0.8%
67Serbia30,75129,17731,28129,71142,53957,957-46.9%
68South Africa29,65130,90931,49730,94026,76728,6403.5%
69Georgia26,00030,30032,80030,40033,00023,00013%
70Lithuania23,25022,98019,56022,37016,14019,23220.9%
71Bosnia and Herzegovina23,14226,85938,10834,34435,46337,191-37.8%
72Hungary22,94026,05024,62026,68029,77033,690-31.9%
73Jamaica22,01221,29319,43118,74219,21618,38719.7%
74Norway21,70921,65021,18819,06517,46216,48431.7%
75Ivory Coast20,74020,75620,77120,56520,18420,0023.7%
76Czechia19,56015,94011,16015,23014,38020,792-5.9%
77Qatar18,22421,84828,37524,92317,61211,99252%
78Malawi17,63618,70016,58718,58127,97129,175-39.6%
79Moldova16,10030,20023,69944,58323,02021,644-25.6%
80Switzerland16,06715,31414,54312,90413,51114,39411.6%
81Venezuela15,70417,27815,41411,34514,48516,460-4.6%
82Denmark15,63015,65016,40016,52016,54016,173-3.4%
83Kenya14,4045,3445,9254,7083,6096,686115.4%
84Philippines14,07014,02313,53813,62813,44413,2905.9%
85Yemen13,81513,83713,84513,76213,90313,870-0.4%
86Dominican Republic13,07113,50413,67616,62516,21215,579-16.1%
87Portugal12,47014,07013,88010,3709,2309,55730.5%
88Croatia11,3708,5507,0203,0004,42010,6227%
89Latvia8,1407,6007,9007,2506,3007,32111.2%
90El Salvador7,65712,9795,4677,1042,2974,90156.2%
91Cyprus7,6507,8607,9708,0609,6608,303-7.9%
92Libya7,1649,5928,6007,4107,4308,670-17.4%
93Mongolia7,0036,1616,0544,7073,7613,92278.6%
94Mauritius5,9385,6153,7166,1317,8408,377-29.1%
95Estonia5,7807,9305,2907,2306,35010,285-43.8%
96Panama5,7616,8889,7574,0182,8802,860101.4%
97Bolivia4,8214,7534,7384,7644,6864,4428.5%
98Ecuador4,6894,6914,7034,6734,6954,742-1.1%
99Slovakia3,8404,8103,2004,9203,6805,335-28%
100Bahrain3,6013,3002,9002,7732,6512,64036.4%
101Guyana3,3583,1452,8172,9162,9812,92214.9%
102Slovenia2,6302,3302,9902,4102,4502,4258.5%
103Dominica2,3492,3142,4062,3262,2102,1489.4%
104Comoros2,2682,1872,1062,0251,9441,86321.7%
105Iceland2,0862,0671,8081,9241,9271,80015.9%
106Hong Kong1,9601,9531,9461,9611,9661,9490.6%
107Trinidad and Tobago1,8971,2231,227973769830128.6%
108Ireland1,7901,7601,8501,7301,6501,6498.6%
109Ethiopia1,6751,6761,6851,6651,6781,710-2%
110Costa Rica1,6511,6531,6511,6481,6601,6440.4%
111Niger1,5931,648872458731,04752.1%
112Puerto Rico1,2981,2831,3021,1038381,2246%
113Fiji1,2891,2961,2931,2801,3151,2830.5%
114Barbados1,24642467693367771574.3%
115East Timor1,1701,1881,1701,1531,1091,0847.9%
116Brunei1,1411,3471,5141,7401,9852,301-50.4%
117Bhutan1,1261,9941,9702,6912,2151,948-42.2%
118Saint Lucia9809118487279089503.2%
119Cape Verde8908898841,4111,1351,470-39.5%
120Malta8206907408107708071.6%
121Madagascar6296296296306276290%
122French Polynesia6286286266316286201.3%
123New Zealand60654854254351950021.2%
124Grenada5958867951,0711,115937-36.5%
125Democratic Republic of Congo3763753733793723691.9%
126Belize272464378219341472-42.4%
127Zimbabwe226220232240240240-5.8%
128Suriname2213969921,2951,7311,730-87.2%
129Ghana1351331361351271285.5%
130Antigua and Barbuda617382818180-23.8%
131Saint Kitts and Nevis313739934947-34%
132Luxembourg30101010102711.1%
132Gabon2323232323230%
133Djibouti7777770%
134Nauru1111110%

Source: FAOSTAT (via Wikipedia)

What you control

Every control has a switch, and the chart editor shows a live preview of the table as you work.

Interactive

Sort buttons with a default sort, a search field, paging with a rows-per-page menu, and a table summary with the chart’s source line beneath it. Limit sorting and search to chosen columns, or turn any control off.

Column menu

An optional menu on every column header with sort ascending, sort descending, and clear sort, plus a checklist filter of the column’s values on the columns you allow.

Appearance

Zebra stripes, hover highlighting, sorted-column highlighting, row or cell borders, compact spacing, no-wrap cells, and a Light, Dark, or Auto color scheme.

Sizing and scrolling

A sticky header, horizontal scrolling with pinned columns, vertical scrolling within a set height, or a responsive mode that collapses columns into expandable rows on small screens. You pick which columns never collapse.

Headers

Declare whether the first row and the first column of the sheet are headers, and name what a row is (“country”, “countries”) for the table summary.

Number formatting

Numeric columns sort by value and display with the chart’s prefixes, suffixes, and locale formatting, so “77,258,256” sorts as a number.

Output everywhere

Shortcodes, the Chart block, and iframe embeds that grow to fit the table. There is also a table image for feeds and previews, and a Table icon in the Charts list.

Reversible

The chart’s own settings are kept while the table is on, so turning the switch off brings the chart back exactly as it was.

Light, Dark, or Auto

Pick the color scheme per table. Light and Dark are fixed. Auto follows the visitor’s operating system setting. The dark table below is a second chart, fed by the one at the top of the page through External Data‘s new Another Chart source. One dataset drives both, and saving the source updates them together.

Cucumber & gherkin production by country, 2017–2022: Tonnes per year, FAOSTAT
RankCountry202220212020201920182017Change 2017–2022
1China77,258,25674,815,09372,927,96970,388,97167,601,86365,156,96318.6%
2Turkey1,938,5451,890,1601,886,2391,916,6451,890,9041,827,7826.1%
3Russia1,635,9031,602,6061,686,9761,626,4121,604,3461,504,9658.7%
4Mexico1,078,2101,038,9991,159,9341,191,6081,072,048956,00512.8%
5Uzbekistan904,390890,433812,728855,058857,076813,59111.2%
6Ukraine825,5901,079,9601,012,5301,034,170985,120896,280-7.9%
7Spain769,970745,910794,880739,200643,660634,82421.3%
8United States595,630642,967567,245670,251700,820857,870-30.6%
9Kazakhstan568,748582,135537,775494,672460,110409,70038.8%
10Japan548,600551,300539,300548,10055,000559,500-1.9%
11Egypt484,425491,650443,500566,155366,661393,43223.1%
12Poland472,200473,000526,500519,400538,680543,726-13.2%
13Indonesia444,057471,941441,286435,973433,923424,9334.5%
14Iran411,3611,483,092571,441667,359650,882751,160-45.2%
15Netherlands400,130440,440430,170410,250410,410400,0000%
16South Korea275,203283,933335,596366,065391,214341,364-19.4%
17Cameroon262,121262,440258,988264,934263,398248,6325.4%
18Tajikistan257,203283,344262,556235,747211,612178,03544.5%
19Azerbaijan246,572245,847226,929248,891223,790220,90311.6%
20Germany233,710242,800216,970249,920267,590256,689-9%
21Belarus228,448212,788216,982230,793226,443236,618-3.5%
22Sudan227,043226,749224,103230,277225,866216,1665%
23Saudi Arabia204,720188,558184,86066,360115,617111,43183.7%
24Iraq195,924185,484242,614149,302138,35396,664102.7%
25Algeria190,925182,890184,362166,045193,647171,61011.3%
26India183,223182,325184,565182,780179,629177,1493.4%
27Thailand177,068176,479177,052177,672174,712178,773-1%
28France175,180200,150213,540139,140137,850145,98120%
29Bangladesh173,998156,744130,259119,136112,974121,25443.5%
30Jordan173,682131,301141,383163,484208,226190,847-9%
31Greece142,490155,800158,510149,740155,480142,2890.1%
32Albania129,896118,171113,685126,632120,351110,21017.9%
33Kyrgyzstan126,811129,159129,122130,007119,569118,2827.2%
34Syria125,495151,844182,415136,567175,758185,208-32.2%
35Lebanon123,685121,005120,090128,710124,480110,14712.3%
36United Arab Emirates120,743114,274105,76591,90371,35053,915124%
37Pakistan112,23147,41746,01477,57368,66465,59771.1%
38Palestine112,014117,938107,120110,050113,870103,1338.6%
39Mali105,87683,95798,75172,94479,03168,88253.7%
40Malaysia102,36996,353101,482103,36385,13488,49215.7%
41Oman97,13993,114102,68273,98373,26762,97754.2%
42Israel80,49295,03891,89294,604101,846103,425-22.2%
43Kuwait79,94873,14348,88096,39158,59170,43613.5%
44Cuba79,18580,23281,71295,700106,708148,497-46.7%
45Romania77,830149,990165,070118,630138,610201,001-61.3%
46Tunisia70,11170,08570,26669,98270,00870,808-1%
47North Korea67,19367,11067,02867,05266,96966,9530.4%
48Morocco63,15559,85146,41657,44847,78748,73529.6%
49Italy61,83062,95060,69060,60054,09054,44413.6%
50Canada60,72157,72057,65565,41657,29562,204-2.4%
51Finland56,96060,03059,91056,13055,33050,76312.2%
52Armenia56,53658,71343,23144,14150,59974,336-23.9%
53Bulgaria52,27053,68053,63072,97074,35054,398-3.9%
54Peru50,55955,01252,10645,44844,28847,6686.1%
55Australia48,26458,20741,23437,05231,83829,80861.9%
56North Macedonia48,19052,95049,11251,01954,31451,532-6.5%
57Taiwan47,08347,97551,33148,96851,22451,264-8.2%
58United Kingdom45,00054,99258,41058,24055,08052,968-15%
59Honduras44,31445,00047,00040,00038,42835,82723.7%
60Austria44,11047,74046,33045,27044,85046,581-5.3%
61Chile37,42937,35337,17437,75937,12636,6372.2%
62Sri Lanka37,14239,09742,22939,04449,76733,12812.1%
63Sweden36,92043,53038,52037,90035,79038,100-3.1%
64Colombia36,79034,11428,42440,98238,74233,6649.3%
65Belgium34,92032,04027,60027,47024,49025,53036.8%
66Turkmenistan34,24334,27534,33234,12034,37234,504-0.8%
67Serbia30,75129,17731,28129,71142,53957,957-46.9%
68South Africa29,65130,90931,49730,94026,76728,6403.5%
69Georgia26,00030,30032,80030,40033,00023,00013%
70Lithuania23,25022,98019,56022,37016,14019,23220.9%
71Bosnia and Herzegovina23,14226,85938,10834,34435,46337,191-37.8%
72Hungary22,94026,05024,62026,68029,77033,690-31.9%
73Jamaica22,01221,29319,43118,74219,21618,38719.7%
74Norway21,70921,65021,18819,06517,46216,48431.7%
75Ivory Coast20,74020,75620,77120,56520,18420,0023.7%
76Czechia19,56015,94011,16015,23014,38020,792-5.9%
77Qatar18,22421,84828,37524,92317,61211,99252%
78Malawi17,63618,70016,58718,58127,97129,175-39.6%
79Moldova16,10030,20023,69944,58323,02021,644-25.6%
80Switzerland16,06715,31414,54312,90413,51114,39411.6%
81Venezuela15,70417,27815,41411,34514,48516,460-4.6%
82Denmark15,63015,65016,40016,52016,54016,173-3.4%
83Kenya14,4045,3445,9254,7083,6096,686115.4%
84Philippines14,07014,02313,53813,62813,44413,2905.9%
85Yemen13,81513,83713,84513,76213,90313,870-0.4%
86Dominican Republic13,07113,50413,67616,62516,21215,579-16.1%
87Portugal12,47014,07013,88010,3709,2309,55730.5%
88Croatia11,3708,5507,0203,0004,42010,6227%
89Latvia8,1407,6007,9007,2506,3007,32111.2%
90El Salvador7,65712,9795,4677,1042,2974,90156.2%
91Cyprus7,6507,8607,9708,0609,6608,303-7.9%
92Libya7,1649,5928,6007,4107,4308,670-17.4%
93Mongolia7,0036,1616,0544,7073,7613,92278.6%
94Mauritius5,9385,6153,7166,1317,8408,377-29.1%
95Estonia5,7807,9305,2907,2306,35010,285-43.8%
96Panama5,7616,8889,7574,0182,8802,860101.4%
97Bolivia4,8214,7534,7384,7644,6864,4428.5%
98Ecuador4,6894,6914,7034,6734,6954,742-1.1%
99Slovakia3,8404,8103,2004,9203,6805,335-28%
100Bahrain3,6013,3002,9002,7732,6512,64036.4%
101Guyana3,3583,1452,8172,9162,9812,92214.9%
102Slovenia2,6302,3302,9902,4102,4502,4258.5%
103Dominica2,3492,3142,4062,3262,2102,1489.4%
104Comoros2,2682,1872,1062,0251,9441,86321.7%
105Iceland2,0862,0671,8081,9241,9271,80015.9%
106Hong Kong1,9601,9531,9461,9611,9661,9490.6%
107Trinidad and Tobago1,8971,2231,227973769830128.6%
108Ireland1,7901,7601,8501,7301,6501,6498.6%
109Ethiopia1,6751,6761,6851,6651,6781,710-2%
110Costa Rica1,6511,6531,6511,6481,6601,6440.4%
111Niger1,5931,648872458731,04752.1%
112Puerto Rico1,2981,2831,3021,1038381,2246%
113Fiji1,2891,2961,2931,2801,3151,2830.5%
114Barbados1,24642467693367771574.3%
115East Timor1,1701,1881,1701,1531,1091,0847.9%
116Brunei1,1411,3471,5141,7401,9852,301-50.4%
117Bhutan1,1261,9941,9702,6912,2151,948-42.2%
118Saint Lucia9809118487279089503.2%
119Cape Verde8908898841,4111,1351,470-39.5%
120Malta8206907408107708071.6%
121Madagascar6296296296306276290%
122French Polynesia6286286266316286201.3%
123New Zealand60654854254351950021.2%
124Grenada5958867951,0711,115937-36.5%
125Democratic Republic of Congo3763753733793723691.9%
126Belize272464378219341472-42.4%
127Zimbabwe226220232240240240-5.8%
128Suriname2213969921,2951,7311,730-87.2%
129Ghana1351331361351271285.5%
130Antigua and Barbuda617382818180-23.8%
131Saint Kitts and Nevis313739934947-34%
132Luxembourg30101010102711.1%
132Gabon2323232323230%
133Djibouti7777770%
134Nauru1111110%

Source: FAOSTAT (via Wikipedia)

Ready to upgrade your charts?

Get M Chart free, and add external data, smart data selection, annotations, a theme builder, and tables with Pro.