workbook = FileAttachment("dataExcelSmall@1.xlsx").xlsx()
workbook.sheetNames
data = workbook.sheet(0, {
headers: true,
range: "A1:R100"
})
Plot.plot({
y: {grid: true},
color: {legend: true},
marks: [
Plot.rectY(data, Plot.binX({y: "count"}, {x: "Size", fill: "Type Shoes"})),
Plot.ruleY([0])
]
})
Plot.plot({
x: {label: "Division"},
y: {label: "Sales@POS"},
color: {legend: true},
marks: [
Plot.barY(data1, {
x: "Division",
y: "Sales@POS",
title: "Sales by Division",
fill: "Division",
raster: true
}),
]
})
data1 = workbook.sheet(0, {
headers: true,
range: "A1:R900"
})
data1
Type Table, then Shift-Enter. Ctrl-space for more options.
Plot.plot({
x: {label: "Sales@Original"},
y: {label: "Sales@POS"},
color: {legend: true},
marks: [
Plot.dot(data1, {
x: "Sales@Original",
y: "Sales@POS",
r: "Quantity",
title: "Sales by Division",
fill: "Division",
opacity: 0.6}),
]
})
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
