Generate Table (N, P, A)

Categories

Number

Italy

France

Portugal

Generate Pie Chart

Colours

Red

Turquoise

Green

Spain

Yellow

Clear all

Generate Table (N)

Generate Table (A)

Generate Table (P)

°

Generate Table (N, P)

Generate Table (N, A)

Generate Table (P, A)

Show Legend

ListAnglesDegText: {"58.06°", "133.55°", "81.29°", "87.1°"}
ListAnglesRadCum: {1.0134169850289656, 3.344276050595586, 4.763059829636138, 6.283185307179586}
B2:10
B3:23
B4:14
ListCat: {"Italy", "France", "Portugal", "Spain"}
ncat = CountIf(x > 0, B2:B50)
ListData: {10, 23, 14, 15}
ListAnglesRad: {1.0134169850289656, 2.330859065566621, 1.4187837790405515, 1.5201254775434483}
ListPercent: {16.129032258064516, 37.096774193548384, 22.58064516129032, 24.193548387096776}
a = Sum(ListPercent)
b = Sum(ListAnglesRad)
ListAngles: {58.064516129032256, 133.5483870967742, 81.29032258064515, 87.09677419354838}
c = Sum(ListAnglesRad)
d = Sum(ListAnglesRad)
e = Sum(ListPercent)
AngleTemp = 6.283185307179586
ListColour: {"Red", "Turquoise", "Green", "Yellow"}
B5:15
TableCat = Insert("Category", ListCat, 1)
TableAngle = Insert("Angle", ListAnglesDegText, 1)
TableNum = Insert("Number", ListData, 1)
ListProportion: {0.16129032258064516, 0.3709677419354839, 0.22580645161290322, 0.24193548387096775}
NBT: {"  ", "  ", "  ", "  "}
ListPercentText: {"16.13%", "37.1%", "22.58%", "24.19%"}
TablePercent = Insert("Percentage", ListPercentText, 1)
TextLabelAngles: {}
x0:6
y0:3
dy:-1
LegendPoints: {(7, 3), (7, 2), (7, 1), (7, 0)}
ntot = Sum(B2:B6)
NumberBlank = Insert("Number", NBT, 1)
AngleBlank = Insert("Angle", NBT, 1)
PercentageBlank = Insert("Percentage", NBT, 1)
LARC0 = Insert(0, ListAnglesRadCum, 1)