Data analysis guides

Map a market stall table to different chart types

·

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.

CSV Chart Builder

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.

RFC 4180 — CSV format

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.

RFC 8259 — JSON numbers

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.

Sources

Put it into practice.

Related guides