SmartQueryTools

Chart Builder

Load any data file and instantly visualize it as a bar chart, line chart, scatter plot, or histogram. Choose columns, pick an aggregation, and draw — pure SVG, no external library, no upload required.

Loading DuckDB engine…

How to use the Chart Builder

  1. Drop a data file on the box or click to browse. CSV, TSV, Parquet, JSON, NDJSON, Arrow, Excel (.xlsx or .xls, first sheet) and YAML files are accepted.
  2. Choose a chart type: Bar, Line, Scatter or Histogram.
  3. For a bar or line chart, pick the X column (the categories) and an aggregation. COUNT counts rows per category. SUM, AVG, MIN and MAX also need a numeric Y column. For a bar chart, set Top N groups (1 to 100, default 20).
  4. For a scatter plot, pick two numeric columns. For a histogram, pick one numeric column and set the number of bins with the slider (5 to 50).
  5. Click Draw Chart. Hover over a bar or point to see its exact value.

Worked example

You have a list of sales, one row per sale, and want to see which product sold the most units.

Input: sales.csv

product,units
Apples,5
Pears,3
Apples,2
Plums,4

Settings

  • Chart type: Bar
  • X column: product
  • Aggregation: SUM
  • Y column: units

Output: bars drawn, largest first (Y axis label: SUM(units))

Apples  7
Plums   4
Pears   3

The two Apples rows (5 and 2) are summed into one bar of 7. Bars are ordered by value, highest first. With COUNT instead of SUM, Apples would show 2 and the other products 1 each. As a line chart, the same data would be ordered by product name instead of by value.

Frequently Asked Questions

How do I make a bar chart from a CSV file?

Drop the CSV here, keep Bar selected, choose the category column as the X column and pick an aggregation. COUNT shows how many rows each category has. SUM with a numeric Y column shows totals. Click Draw Chart. Bars are sorted from largest to smallest.

What is the difference between a bar chart and a histogram here?

A bar chart groups rows by the exact values of a column, such as product names. A histogram takes one numeric column, splits its range into equal-width bins and counts how many values fall in each. Each histogram bar is labelled with the start of its bin.

Are there limits on how much data is drawn?

Bar charts show the top N groups, up to 100. Line charts show up to 100 points, sorted by the X column. Scatter plots draw the first 500 rows where both columns have a value. Histograms use every non-empty value in the column. The file itself can have many more rows, because grouping and counting happen before drawing.

Can I download the chart as an image?

There is no download button yet. The chart is drawn as SVG, so a screenshot stays sharp. To reuse the numbers behind it, run the same GROUP BY in the SQL Query tool and export the result as CSV.

Is my data uploaded to make the chart?

No. The file is read, grouped and drawn inside your browser tab. Nothing is sent to a server.

Related tools