QStudio provides a powerful and flexible charting system designed to make data visualization effortless. With a wide range of chart types—from time series, line, bar, and area charts to heatmaps, scatter plots, histograms, and more—qStudio makes it easy to explore and present your data with clarity. Every chart supports multiple visual themes, allowing you to match your preferred style or dashboard aesthetic. In addition, qStudio offers extensive configuration options, including colors, series settings, axis controls, tooltips, and layout adjustments, giving you full control to tailor each chart to your analysis and presentation needs.

For each of the chart types their data format expected together with some examples are shown below

Themes: dark-finance, dark-original, dark, excel, high-contrast, light, powerbi, tabular

Time Series

Format

  1. The first date/time column found will be used for the x-axis.
  2. Each numerical column represents one time series line on the chart.

Day Sines

A sine/cosine wave over a period of days.

A sine/cosine wave over a period of days. A sine/cosine wave over a period of days.
  • kdb+ q
  • DuckDB

Step Plot

Format

  1. The first date/time column found will be used for the x-axis.
  2. Each numerical column represents one time series line on the chart.

Day Sines

A sine/cosine wave over a period of days.

A sine/cosine wave over a period of days. A sine/cosine wave over a period of days.
  • kdb+ q
  • DuckDB

Area Chart

Format

  1. The first string columns are used as category labels.
  2. Whatever numeric columns appear after the strings represents a separate series in the chart.

Multiple Series with Time X-Axis

2 series are shown, one for Sales, One for Costs. x-axis is in months.

2 series are shown, one for Sales, One for Costs. x-axis is in months. 2 series are shown, one for Sales, One for Costs. x-axis is in months.
  • kdb+ q
  • DuckDB

Single Category

One number column generates one series.

One number column generates one series. One number column generates one series.
  • kdb+ q
  • DuckDB

Multiple series

Each column is a new series/colored bar.

Each column is a new series/colored bar. Each column is a new series/colored bar.
  • kdb+ q
  • DuckDB

Multiple series with many categories on the X-axis

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden. Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.
  • kdb+ q
  • DuckDB

Bar Chart

Format

  1. The first string columns are used as category labels.
  2. Whatever numeric columns appear after the strings represents a separate series in the chart.

Multiple Series with Time X-Axis

2 series are shown, one for Sales, One for Costs. x-axis is in months.

2 series are shown, one for Sales, One for Costs. x-axis is in months. 2 series are shown, one for Sales, One for Costs. x-axis is in months.
  • kdb+ q
  • DuckDB

Single Category

One number column generates one series.

One number column generates one series. One number column generates one series.
  • kdb+ q
  • DuckDB

Multiple series

Each column is a new series/colored bar.

Each column is a new series/colored bar. Each column is a new series/colored bar.
  • kdb+ q
  • DuckDB

Multiple series with many categories on the X-axis

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden. Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.
  • kdb+ q
  • DuckDB

Bar Chart Stacked

Format

  1. The first string columns are used as category labels.
  2. Whatever numeric columns appear after the strings represents a separate series in the chart.

Multiple Series with Time X-Axis

2 series are shown, one for Sales, One for Costs. x-axis is in months.

2 series are shown, one for Sales, One for Costs. x-axis is in months. 2 series are shown, one for Sales, One for Costs. x-axis is in months.
  • kdb+ q
  • DuckDB

Single Category

One number column generates one series.

One number column generates one series. One number column generates one series.
  • kdb+ q
  • DuckDB

Multiple series

Each column is a new series/colored bar.

Each column is a new series/colored bar. Each column is a new series/colored bar.
  • kdb+ q
  • DuckDB

Multiple series with many categories on the X-axis

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden. Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.
  • kdb+ q
  • DuckDB

Bubble Chart

Format

  1. The first string columns are used as category labels.
  2. There must then be 3 numeric columns which are used for x-coord, y-coord, size in that order.

Single series

The three columns are used for x-axis,y-axis and size respectively. Notice the GdpPerCapita column has been divided to make it similar sized to the othercolumns so that the bubbles are a sensible size.

The three columns are used for x-axis,y-axis and size respectively. Notice the GdpPerCapita column has been divided to make it similar sized to the othercolumns so that the bubbles are a sensible size. The three columns are used for x-axis,y-axis and size respectively. Notice the GdpPerCapita column has been divided to make it similar sized to the othercolumns so that the bubbles are a sensible size.
  • kdb+ q
  • DuckDB

Candlestick

Format

  1. The table should contain columns labelled open/high/low/close/volume
  2. but must atleast contain high/low to allow it to be drawn.
  3. If you send only daily weekdays, weekend values are hidden.

Prices going up

A Candlestick showing price movements and fluctuating volume over a period of 6 weeks

A Candlestick showing price movements and fluctuating volume over a period of 6 weeks A Candlestick showing price movements and fluctuating volume over a period of 6 weeks
  • kdb+ q
  • DuckDB

Rising Prices, No Volume

A candlestick showing only price movements, no volume column.

A candlestick showing only price movements, no volume column. A candlestick showing only price movements, no volume column.
  • kdb+ q
  • DuckDB

Rising Prices, Only High Low Columns Shown

A candlestick showing only high low prices.

A candlestick showing only high low prices. A candlestick showing only high low prices.
  • kdb+ q
  • DuckDB

Heat Map

Format

A HeatMap works best with 1+ string columns.

  1. Starting from the left each string column is taken as one nesting level
  2. The first numerical column will be taken as size, the second as colour.

Country GDP's

The continent column is a top-level branch, the country column becomes leafs.The first two columns are GDP and GDP per Capita which become the size and color of the leafs respectively.

The continent column is a top-level branch, the country column becomes leafs.The first two columns are GDP and GDP per Capita which become the size and color of the leafs respectively. The continent column is a top-level branch, the country column becomes leafs.The first two columns are GDP and GDP per Capita which become the size and color of the leafs respectively.
  • kdb+ q
  • DuckDB

Histogram

Format

Each Numeric column represents a separate series in the histogram. The series values are placed into buckets and their frquency tallied.

Profit Distribution

Distribution of Returns and Losses

Distribution of Returns and Losses Distribution of Returns and Losses
  • kdb+ q
  • DuckDB

Line Chart

Format

  1. The first string columns are used as category labels.
  2. Whatever numeric columns appear after the strings represents a separate series in the chart.

Multiple Series with Time X-Axis

2 series are shown, one for Sales, One for Costs. x-axis is in months.

2 series are shown, one for Sales, One for Costs. x-axis is in months. 2 series are shown, one for Sales, One for Costs. x-axis is in months.
  • kdb+ q
  • DuckDB

Single Category

One number column generates one series.

One number column generates one series. One number column generates one series.
  • kdb+ q
  • DuckDB

Multiple series

Each column is a new series/colored bar.

Each column is a new series/colored bar. Each column is a new series/colored bar.
  • kdb+ q
  • DuckDB

Multiple series with many categories on the X-axis

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.

Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden. Each column is a new series/colored bar. When there are a lot of categories, some labels are hidden.
  • kdb+ q
  • DuckDB

Pie Chart

Format

  1. Each numerical column represents a pie chart.
  2. The title of each pie chart will be the column title.
  3. Each row will be a section of the pie and will use the row title as a label.

Single Pie Chart Example

A single numerical columns gives a single pie chart for that column.

A single numerical columns gives a single pie chart for that column. A single numerical columns gives a single pie chart for that column.
  • kdb+ q
  • DuckDB

Multiple Pie Chart Example

Using multiple numerical columns gives a pie chart for each column.

Using multiple numerical columns gives a pie chart for each column. Using multiple numerical columns gives a pie chart for each column.
  • kdb+ q
  • DuckDB

Scatter Plot

Format

  1. Two or more numeric columns are required.
  3. The values in the first column are used for the X-axis.
  5. The values in following columns are used for the Y-axis.
  7. Each column is displayed with a separate color.

Country Population and GDP

The first column GDP is used for the x-axis. The subsequent columns are then plotted against that x axis as separate colored series.

The first column GDP is used for the x-axis. The subsequent columns are then plotted against that x axis as separate colored series. The first column GDP is used for the x-axis. The subsequent columns are then plotted against that x axis as separate colored series.
  • kdb+ q
  • DuckDB

Day Sines

A sine/cosine wave over a period of days.

A sine/cosine wave over a period of days. A sine/cosine wave over a period of days.
  • kdb+ q
  • DuckDB

Data Table

Format

Any format of table is acceptable, all rows/columns will be shown as a plain table.

Many Columned Table

All rows/columns will be shown as a plain table.

All rows/columns will be shown as a plain table.
  • kdb+ q
  • DuckDB