Map a market stall table to different chart types
Admin ·
A market spreadsheet records crates moved and returns by stall. Pick the chart based on the comparison you need, then verify the plotted rows against the source.
Map the stall names and both numeric columns
Select Load example and Read columns. Keep Bar and Stall as the label column. Select Crates and Returns as value columns, then build. The quoted comma in Coffee, East belongs to the stall name, so the chart has three stalls and two series.
At Corner, Crates is −2 and its bar extends below zero. Returns is zero. Open Show plotted rows to check the source numbers and the label 西 Market.
Choose Returns when you need part-to-whole shares
Switch to Pie and choose Crates. Build chart reports the negative value at data row 3. Choose Returns and build again. With Value labels checked, Coffee, East accounts for 66.7% and 西 Market for 33.3%. Corner has zero returns, so it has no visible slice.
Check the exported image and the mapped values
Download PNG and check that its size is 1200 by 680 pixels and the title and legend match your preview. Download plot data to read the mapped labels and original numeric spellings as JSON strings.
If a selected JSON field contains a number in quotation marks, edit that row or change the mapping. Use a JSON number when the field represents a chart coordinate.
Common questions
Which column goes on the horizontal axis of a scatter plot?
Choose the Numeric X column. Each row supplies one X coordinate and one value from the Numeric Y column.
What happens to a nested JSON object?
Nested values remain in the source and cannot serve as a chart label or numeric coordinate. Select scalar fields for the chart.