Chart Types

Explanation of Chart SQL chart types and visualization modes

Chart Types

ChartSQL supports the following chart types. You can see Overview for all of the types available

• Column

• Pie

• Bar

• Area

• Line

• Scatter

• Bubble

• Combo

• Heatmap

Many more chart types, tables, cards and advanced visualizations are being planned.

Detection Modes

ChartSQL helps you create visualizations quickly by detecting your column types, categories and series. It has three modes: Auto, Assist and Manual

Auto Mode

In Auto Mode, an appropriate chart type will be chosen based on the data type and number of columns in your SQL query. This is useful for quickly visualizing your data.

See Auto Charts for examples of all the available auto mode charts

Assist Mode

In Assist Mode, you define the @chart directive, and optionally the @category and @series directives. ChartSQL will fill in any unspecified @category or @series based on the available columns and their data types. Use Assist Mode when you know the chart type, but want ChartSQL to select the columns.

Manual Mode

In Manual Mode, you define the @chart, the @category and @series, and ChartSQL will only display those columns in your visualizations. Any extra columns in your query are ignored. You use this when you want full control over the data being visualized.